home
***
CD-ROM
|
disk
|
FTP
|
other
***
search
/
Business Assistant
/
Business Assistant.iso
/
home
/
stbgt17
/
st-bgt.exe
/
MANUAL.DOC
< prev
next >
Wrap
Text File
|
1992-08-05
|
144KB
|
2,737 lines
ST-BUDGET v1.7
Budget Tracking System
User's Guide
Copyright (c) SoftTalk Computing Inc. 1991-1992
P.O.Box 68028
Calgary, AB. Canada T3G 3N8
Phone: (403) 241-1519
ST-BUDGET v1.7
Budget Tracking System
TABLE OF CONTENTS
INTRODUCTION
1.1 Key features
1.2 Registration
1.3 License
1.4 Limited Warranty
1.5 Site Licenses and quantity purchases
1.6 Technical Support
1.7 System Requirements
1.8 Installation
1.9 Getting Started
OPERATIONS
2.0 General
2.1 Main Menu
2.2 Tables
2.2.1 Accounts
2.2.2 Entities
2.2.3 Periods
2.2.4 Budget Year
2.3 Budget
2.3.1 Tracking
2.3.1.1 Yearly Budgets
2.3.1.1.1 Accounts
2.3.1.1.2 Enter Budget
2.3.1.1.3 Enter Actual
2.3.1.2 Monthly Budgets
2.3.2.1 Accounts
2.3.2.2 Enter Actual
2.3.2.2.1 View/Edit Actuals
2.3.2.2.2 Default Transactions
2.3.2 Online Budget Summary
2.3.2.1 Monthly Budget vs Actual
2.3.2.2 Quarterly Budget vs Actual
2.3.2.3 Yearly Budget vs Actual
2.3.3 Exporting
2.3.3.1 Export Budget data to DBF file
2.3.3.2 Export Budget & Actual data to Ascii Delimited file
2.3.3.3 Export Budget data to Ascii Delimited file
2.3.3.4 Export Budget & Actual data to Ascii Delimited file
2.3.4 Importing
2.3.4.1 Import Budget data from DBF file
2.3.4.2 Import Budget data from Ascii Delimited file
2.4 Reports
2.4.1 Daily Transactions Report
2.4.2 Monthly Budget vs Actual Report
2.4.3 Quarterly Budget vs Actual Report
2.4.4 Yearly Budget vs Actual Report
2.5 Utilities
2.5.1 Initialize DataBase
2.5.2 Rebuild Index Files
2.5.3 Backup DataBase Files
2.5.4 Restore DataBase Files
INTRODUCTION
1.1 KEY FEATURES
ST-BUDGET is one of the most powerful tool for budgeting and tracking.
It is designed for CORPORATE, EDUCATION INSTITUTE, SMALL BUSINESS and
PROFESSIONAL use. Key features include User-Defined Entities
(i.e. Department, Project, Cost Centre), Support Multi-level Chart of
Accounts, Numerous Budgeting Methods, Tracking Actuals, Online budget
summaries, Numerous Reports, Export Budget Data to DBF file or ascii
delimited file, Utility to create budget spreadsheet (wk1) file.
1.2 REGISTRATION
The registration fee for a single copy of ST-BUDGET is US$89.00
(or Cdn$99.00 GST included) plus $10.00 for Shipping/Handling. Payment
of this fee entitles you to:
- A disk with the latest version of ST-BUDGET.
- One copy of printed and spiral-bound ST-BUDGET manual.
- A fully functional trial version of our other product ST-EIS
Executive Information System which allows you to consolidate
multi-level entity budgets.
- 90 days free technical support via electronic mail, telephone
or CompuServe.
Please send check or money order to:
SoftTalk Computing Inc.
P.O.Box 68028
Calgary, AB. Canada T3G 3N8
Voice: (403) 241-1519 CompuServe: 70242,452
1.3 LICENSE
The ST-BUDGET program and all other programs and documentations
distributed are Copyright SoftTalk Computing Inc., and are protected
by CANADA and International Copyright law. You are granted a licence
to use your copy of ST-BUDGET only under the terms and conditions
specified in this licence agreement.
ST-BUDGET is distributed in two forms. A REGISTERED version of ST-BUDGET
is a copy purchased from SoftTalk Computing Inc. which includes a serial
number. Distribution of the REGISTERED version is in violation of
license agreements and copyright law. If you have a registered copy of
ST-BUDGET which is licensed for use on a single computer, you may install
it on two computers used at two different locations, provided there is no
possibility that the two computers will be in use at the same time. You
may also install your registered copy of ST-BUDGET on a computer attached
to a network, provided there is no possibility that your copy will be
used by more users than it is licensed for.
A SHAREWARE version of ST-BUDGET is a copy distributed for evaluation
purpose. It allows you to try it before you buy it. If you are using it,
you must purchase a registered copy. You are encouraged to pass the
SHAREWARE version of ST-BUDGET along to others.
1.4 LIMITED WARRANTY
The software and accompanying written materials (including instructions
for use) are provided "AS IS" without warranty of any kind. Further,
SoftTalk Computing does not warrant, guarantee or make any
representations regarding the use, or the results of use, of the software
or written materials in terms of correctness, accuracy, reliability,
currentness or otherwise. The entire risk as to the results and
performance of the software is assumed by you. If the software or written
materials are defective you, and not SoftTalk Computing Inc. or its dealers,
distributors, agents or employees, assume the entire cost of all necessary
servicing, repair, or correction. Neither SoftTalk computing Inc. nor
any direct, indirect, consequential or incidental damages (including
damages for loss of business profits, business interruption, loss of
business information, and the like) arising out of the use or inability
to use such product even if SoftTalk Computing Inc. has been advised
of the possibility of such damages.
1.5 SITE LICENSES AND QUANTITY PURCHASES
We offer quantity discounts as well as site licensing. Site licensing
agreements allow duplication and distribution of a specified number
of multiple copies within the licensed institution. Site license fees
are based upon the number of users of ST-BUDGET. Please call or
write for more information.
1.6 TECHNICAL SUPPORT
Technical support for ST-BUDGET is available to registered users.
You can contact SoftTalk Computing Inc. for support by mail,
telephone or CompuServe.
SoftTalk Computing Inc.
P.O.Box 68028
Calgary, AB. Canada T3G 3N8
Voice: (403) 241-1519 Monday - Friday 8:00 am - 6:00 pm
CompuServe: 70242,452
1.7 SYSTEM REQUIREMENTS
ST-BUDGET is designed to run on a PC, AT or 386 computers. Minimum
requirements are:
- 640K of RAM memory.
- DOS 3.1 or later.
- One hard disk with a minimum of 1 MB free disk space.
- An 80-column Monochrome or color monitor.
- An 132-column printer.
1.8 INSTALLATION
To install the ST-BUDGET system, insert the program disk in drive A.
At the C prompt, type :
A:INSTALL A: C:
and follow the instructions provided by the installation program.
1.9 GETTING STARTED
Change to the directory where you installed the ST-BUDGET
system. Type
Budget
and press Enter key to start up the system.
OPERATIONS
2.0 GENERAL
SAMPLE DATA - The ST-BUDGET system comes with a set of sample data so
that you can immediately try it out without setting up anything. Once
you familiar the system, you can intialize a new empty set of data
files using the "Initialize Database" option on the Utilities menu item,
and then start entering your budget data.
USER INTERFACES - The ST-BUDGET system uses many user-friendly
interfaces such as menu bar, pull-down menu, help screen, browse screen
to make it very easy to understand and operate. We will discuss these
features briefly.
MENU BAR - The menu bar displays all the menu items. To select a menu
item, simply move the cursor to that item and press the ENTER key to
execute.
▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓
▓┌───────────────────────────────────────────────────────────────┐▓▓
▓│ Tables Budget Reports Utilities Quit │▓▓
▓└───────────────────────────────────────────────────────────────┘▓▓
▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓
PULL-DOWN MENU - It provides a list of options. To select an option,
move the cursor to the row that contains the option and press the ENTER
key to execute.
▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓
▓┌──────────────────────────────────────────────────────────────┐ ▓▓
▓│ Tables Budget Reports Utilities Quit │ ▓▓
▓└─┬───────────────┬────────────────────────────────────────────┘ ▓▓
▓▓▓│Accounts │ ▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓
▓▓▓│Entities │ ▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓
▓▓▓│Periods │ ▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓
▓▓▓│Budget Years │ ▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓
▓▓▓└───────────────┘ ▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓
▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓
HELP SCREEN - The fastest way to get help is to use the HELP (F1 key)
command. When you issue this command, a pop-up help screen will appear.
The information displayed will relate to your current option.
┌─────────────────────────────────────────────────────────────────────────┐
│ Tables Budget Reports Utilities Quit │
└─────────────────────────────────────────────────────────────────────────┘
▓▓┌───────────────┐▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓
▓▓│Accounts │▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓
▓▓│En╔═[ Help ]═══════════════════════════════════════════════════════╗▓▓▓▓
▓▓│Pe║ ║▓▓▓▓
▓▓└──║ Accounts ║▓▓▓▓
▓▓▓▓▓║ ║▓▓▓▓
▓▓▓▓▓║This option allows to set up the chart of Accounts table ║▓▓▓▓
▓▓▓▓▓║ ║▓▓▓▓
▓▓▓▓▓║ ║▓▓▓▓
▓▓▓▓▓║ ║▓▓▓▓
▓▓▓▓▓║ ║▓▓▓▓
▓▓▓▓▓║ ║▓▓▓▓
▓▓▓▓▓╚════════════════════════════════════════════════════════════════╝▓▓▓▓
▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓
▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓
▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓
COMMON HOTKEYS - The ST-BUDGET system use the following common hotkeys
throughout the entire system:
F1-Help Display help screen
F3-Add Add record
F4-Delete Delete Record
F5-Toggle To get a full view of single record edit screen.
F9-Print Print a hard copy of listing
F10-Process Process the selected function
Esc-Exit Exit screen or system
BROWSING MULTIPLE RECORDS SCREEN - The Browse screen allows you to
view multiple records. The left top corner displays the title, the
right top corner displays the status of the record counter.
You can use the following cursor key to navigate the browse
screen:
Down Arrow Move cursor to next row or next field
Up Arrow Move cursor to previous row or field
PgUp Move cursor to previous set of rows
PgDn Move cursor to next set of rows
Right Arrow Move cursor to next field
Tab Move cursor to next field
▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓
▓▓▓ ╒═ [ Account ] ═════════════════════[ 3 of 13 ]══╕ ▓▓▓
▓▓▓ │Account Description Type│ ▓▓▓
▓▓▓ │═══════════════╤═══════════════════════════╤═════│ ▓▓▓
▓▓▓ │401 │ Revenue - Tuition Fee │ R │ ▓▓▓
▓▓▓ │501 │ Salary │ E │ ▓▓▓
▓▓▓ │502 │ Office Supplies │ E │ ▓▓▓
▓▓▓ │503 │ Telephone │ E │ ▓▓▓
▓▓▓ ╘═══════════════╧═══════════════════════════╧═════╛ ▓▓▓
▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓
2.1 MAIN MENU
───────────────────────────────────────────────────────────────────────
Type BUDGET at the DOS prompt to display the ST-BUDGET main menu.
It consists of the following menu items:
TABLES - this menu item provides options to maintain the required
tables (i.e. Accounts, Entities, Periods ) for budgeting.
BUDGET - this option allows you to assign accounts to entity, and
then enter budget and actual data.
REPORTS - this menu item provides options to generate daily, monthly,
quarterly and yearly reports.
UTILITIES - this menu item provides options to intialize database,
rebuild indexes, backup and restore database files.
QUIT - Exit this screen.
┌─────────────────────────────────────────────────────────────────────────┐
│ Tables Budget Reports Utilities Quit │
└─────────────────────────────────────────────────────────────────────────┘
▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓
▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓
▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓
▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓
▓▓▓▓▓▓▓▓▓▓▓▓╔══════════════════════════════════════════════════════╗▓▓▓▓▓▓▓
▓▓▓▓▓▓▓▓▓▓▓▓║ ║▓▓▓▓▓▓▓
▓▓▓▓▓▓▓▓▓▓▓▓║ ST-BUDGET ║▓▓▓▓▓▓▓
▓▓▓▓▓▓▓▓▓▓▓▓║ ║▓▓▓▓▓▓▓
▓▓▓▓▓▓▓▓▓▓▓▓║ Budget Tracking System ║▓▓▓▓▓▓▓
▓▓▓▓▓▓▓▓▓▓▓▓║ Version 1.6 ║▓▓▓▓▓▓▓
▓▓▓▓▓▓▓▓▓▓▓▓║ ║▓▓▓▓▓▓▓
▓▓▓▓▓▓▓▓▓▓▓▓║ ║▓▓▓▓▓▓▓
▓▓▓▓▓▓▓▓▓▓▓▓║ Copyright (c) SoftTalk Computing Inc. 1991-1992 ║▓▓▓▓▓▓▓
▓▓▓▓▓▓▓▓▓▓▓▓║ P.O.Box 68028 ║▓▓▓▓▓▓▓
▓▓▓▓▓▓▓▓▓▓▓▓║ Calgary, AB. Canada T3G 3N8 ║▓▓▓▓▓▓▓
▓▓▓▓▓▓▓▓▓▓▓▓║ Phone: (403) 241-1519 ║▓▓▓▓▓▓▓
▓▓▓▓▓▓▓▓▓▓▓▓║ ║▓▓▓▓▓▓▓
▓▓▓▓▓▓▓▓▓▓▓▓╚══════════════════════════════════════════════════════╝▓▓▓▓▓▓▓
▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓
▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓
▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓
▓▓▓▓▓Press F1 key for help menu, Enter key to execute, Esc key to exit▓▓▓▓▓
SELECTING OPTION - Move the cursor to the required menu item and press
the Enter key to execute.
2.2 Tables
────────────────────────────────────────────────────────────────────
The following screen will be displayed when the Tables option is
selected from the Menu. It provides the following options:
ACCOUNTS - this option allows you to browse and edit the ACCOUNTS
table.
ENTITIES - this option allows you to set up the entities for
budgeting.
PERIODS - this option allows you to browse and edit the PERIODS
table.
BUDGET YEAR - this option allows you to change the default
budget year.
┌─────────────────────────────────────────────────────────────────────────┐
│ Tables Budget Reports Utilities Quit │
└─────────────────────────────────────────────────────────────────────────┘
▓▓┌───────────────┐▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓
▓▓│Accounts │▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓
▓▓│Entities │▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓
▓▓│Periods │▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓
▓▓│Budget Year │════════════════════════════════════════════════╗▓▓▓▓▓▓
▓▓│ │ ║▓▓▓▓▓▓
▓▓└───────────────┘ ST-BUDGET ║▓▓▓▓▓▓
▓▓▓▓▓▓▓▓▓▓▓▓║ ║▓▓▓▓▓▓
▓▓▓▓▓▓▓▓▓▓▓▓║ Budget Tracking System ║▓▓▓▓▓▓
▓▓▓▓▓▓▓▓▓▓▓▓║ Version 1.6 ║▓▓▓▓▓▓
▓▓▓▓▓▓▓▓▓▓▓▓║ ║▓▓▓▓▓▓
▓▓▓▓▓▓▓▓▓▓▓▓║ ║▓▓▓▓▓▓
▓▓▓▓▓▓▓▓▓▓▓▓║ Copyright (c) SoftTalk Computing Inc. 1991 ║▓▓▓▓▓▓
▓▓▓▓▓▓▓▓▓▓▓▓║ P.O.Box 68028 ║▓▓▓▓▓▓
▓▓▓▓▓▓▓▓▓▓▓▓║ Calgary, AB. Canada T3G 3N8 ║▓▓▓▓▓▓
▓▓▓▓▓▓▓▓▓▓▓▓║ Phone: (403) 241-1519 ║▓▓▓▓▓▓
▓▓▓▓▓▓▓▓▓▓▓▓║ ║▓▓▓▓▓▓
▓▓▓▓▓▓▓▓▓▓▓▓╚══════════════════════════════════════════════════════╝▓▓▓▓▓▓
▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓
▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓
▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓
F1-help, Enter-Execute, Esc-Exit
SELECTING OPTION - Select the required option from the pull-down menu and
press the Enter key to execute.
2.2.1 Accounts
─────────────────────────────────────────────────────────────────────
The following screen will be displayed when the Account option is
selected from the TABLE menu. It allows you to browse or edit
accounts. Each account record consists of the following data elements:
Account - The unique account code, up to 14 characters.
Description - The description of the account, up to 25 characters.
Type - The account type ( R=Revenue, E=Expense, T=Total ).
Enter-Edit F2-Sub-Level F3-Add F4-Delete F9-Print
▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓
▓▓╒═ [ Account ] ══════════════════════════════════[ 1 of 1 ]══╕▓▓▓▓▓▓▓▓
▓▓│Account Description Type Sub-Level │▓▓▓▓▓▓▓▓
▓▓│═╒═ [ Net Income ] ═══════════════════════════════[ 1 of 2 ]══╕▓▓▓▓▓▓
▓▓│1│Account Description Type Sub-Level │▓▓▓▓▓▓
▓▓│ │═╒═ [ Revenues ] ═════════════════════════════════[ 1 of 3 ]══╕▓▓▓▓
▓▓│ │4│Account Description Type Sub-Level │▓▓▓▓
▓▓│ │5│═══════════════╤═══════════════════════════╤══════╤═══════════│▓▓▓▓
▓▓│ │ │401 │ Tuition Fee │ R │ None │▓▓▓▓
▓▓│ │ │402 │ Lab Fee │ R │ None │▓▓▓▓
▓▓│ │ │403 │ Book Fee │ R │ None │▓▓▓▓
▓▓╘═│ │ │ │ │ │▓▓▓▓
▓▓▓▓│ │ │ │ │ │▓▓▓▓
▓▓▓▓╘═│ │ │ │ │▓▓▓▓
▓▓▓▓▓▓│ │ │ │ │▓▓▓▓
▓▓▓▓▓▓╘═══════════════╧═══════════════════════════╧══════╧═══════════╛▓▓▓▓
▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓
▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓
The Account screen allows you to set up the chart of accounts table up to
maximum of 4 levels. We have provided an example of the following set up
for demonstration.
1 Net Income
4 Revenues
401 Tuition Fee
402 Lab Fee
403 Book Fee
5 Expenses
501 Salary
5011 Salary - Full Time
5012 Salary - Wages
502 Office Supplies
503 Telephone
ADDING ACCOUNT RECORD - Move the cursor to the row where you want
to add the record and press the F3 key. The system will insert a blank
row below the selected row and position the cursor to the ACCOUNT field.
Enter the ACCOUNT code and press the ENTER key. If the ACCOUNT code is
valid, the system will add the new record into the ACCOUNT table, and
allows you to enter the remaining fields.
EDITING ACCOUNT RECORD - Move the cursor to the field where you
wish to make changes and press the Enter key. The system will position
the cursor to the first character of the field and allow you to edit the
field. Type in the changes and press the ENTER key. The system will update
the field in the ACCOUNT table and position the cursor key to next field.
DELETING ACCOUNT RECORD - Move the cursor to the row that contains
the account record and press the F4 key. The system will remove that
account record from the table and shift up all the following accounts.
NEXT ACCOUNT LEVEL - Move the cursor to the account you wish to select
and press F2 key.
PRINT - Press F9 key to print a hard copy of Account Listing
CHART OF ACCOUNTS
=================
ACCOUNT DESCRIPTION TYPE LEVEL PARENT
-------------------------------------------------------------------
1 Net Income T 1
4 Revenues R 2 1
401 Tuition Fee R 3 4
402 Lab Fee R 3 4
403 Book Fee R 3 4
5 Expenses E 2 1
501 Salary E 3 5
5011 Salary - Full-Time E 4 501
5012 Salary - Wages E 4 501
502 Office Supplies E 4 5
503 Telephone E 4 5
504 Insurance E 4 5
2.2.2 Entities
────────────────────────────────────────────────────────────────────
The following screen will be displayed when the Entities option is
selected from the Tables menu. It allows you to browse or edit the
the entity records. Each entity record consists of two data elements:
ID - A 14 character unique key to identify the entity. Entity
can be defined for Department, Project, Cost Centre or any
object which is used for budgeting.
NAME - A 25 character code to describe the entity.
F1-Help <Enter>Edit F3-Add F4-Delete <Esc>Exit
▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓
▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓
▓▓╒═ [ Entities ] ════════════════════════════[ 1 of 3 ]══╕▓▓▓▓▓▓▓▓▓▓▓▓
▓▓│ID NAME │▓▓▓▓▓▓▓▓▓▓▓▓
▓▓│═══════════════╤═════════════════════════════════════════│▓▓▓▓▓▓▓▓▓▓▓▓
▓▓│101 │ Computer Science Department │▓▓▓▓▓▓▓▓▓▓▓▓
▓▓│201 │ Engineering Department │▓▓▓▓▓▓▓▓▓▓▓▓
▓▓│301 │ Business Department │▓▓▓▓▓▓▓▓▓▓▓▓
▓▓│ │ │▓▓▓▓▓▓▓▓▓▓▓▓
▓▓│ │ │▓▓▓▓▓▓▓▓▓▓▓▓
▓▓╘═══════════════╧═════════════════════════════════════════╛▓▓▓▓▓▓▓▓▓▓▓▓
▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓
▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓
ADDING ENTITY RECORD - Move the cursor to the row where you want
to add the record and press the F3 key. The system will insert a blank
row below the selected row and position the cursor to the ID field.
Enter the Entity ID and press the ENTER key. If the Entity Id is
valid, the system will add the new record into the Entity table, and
allows you to enter the remaining fields.
EDITING ENTITY RECORD - Move the cursor to the field where you
wish to make changes and press the Enter key. The system will position
the cursor to the first character of the field and allow you to edit the
field. Type in the changes and press the ENTER key. The system will update
the field in the Entity table and position the cursor key to next field.
DELETING ENTITY RECORD - Move the cursor to the row that contains
the account record and press the F4 key. The system will remove that
entity record from the table and shift up all the following accounts.
2.2.3 Periods
────────────────────────────────────────────────────────────────────
The following screen will be displayed when the Periods option is
selected from the TABLES menu. It allows you to browse or edit
the following period record data:
Year - The budget year, to identify the budgeting cycle.
Period 1-12 - The start-date (mm/dd/yy) of the period.
Period 13 - The end-date (mm/dd/yy) of the budgeting cycle.
F1-Help Enter-Edit F3-Add F4-Delete Esc-Exit
▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓
▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓
▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓
▓▓╒═ [ Periods ] ════════════════════════════════[ 1 of 3 ]══╕▓▓
▓▓│Year Period 1 Period 2 Period 3 Period 4 Period 5 │▓▓
▓▓│═════╤══════════╤══════════╤══════════╤══════════╤══════════│▓▓
▓▓│1989 │ 01/01/89 │ 02/01/89 │ 03/01/89 │ 04/01/89 │ 05/01/89 │▓▓
▓▓│1990 │ 01/01/90 │ 02/01/90 │ 03/01/90 │ 04/01/90 │ 05/01/90 │▓▓
▓▓│1991 │ 01/01/91 │ 02/01/91 │ 03/01/91 │ 04/01/91 │ 05/01/91 │▓▓
▓▓│ │ │ │ │ │ │▓▓
▓▓│ │ │ │ │ │ │▓▓
▓▓│ │ │ │ │ │ │▓▓
▓▓│ │ │ │ │ │ │▓▓
▓▓│ │ │ │ │ │ │▓▓
▓▓│ │ │ │ │ │ │▓▓
▓▓╘═════╧══════════╧══════════╧══════════╧══════════╧══════════╛▓▓
▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓
▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓
▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓
▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓
The Periods table allows you to set up the fiscal years period.
You can start your budgeting cycle at any month of the year.
ADDING PERIOD RECORD - Move the cursor to the row where you want to
add the record and press the F3 key. The system will insert a blank row
below the selected row and position the cursor to the year field. Enter
the year code and press the ENTER key. If the year code is valid, the
system will add the new record into the period table, assign the default
start-date to each period, then position the cursor to next field for
data entry.
EDITING PERIOD RECORD - Move the cursor to the field where you wish
to make changes and press the INSERT key. The system will position the
cursor to the first character of the field and allow you to enter the
changes. Edit the field and press the ENTER key. The system will update
the changes into period table, and the position the cursor to next
field.
DELETING PERIOD RECORD - Move the cursor to the row that contains
the period record and press the F4 key. The system will remove that
period record from the period table, shift up the following records.
2.2.4 Budget Year
───────────────────────────────────────────────────────────────────────
The following screen will be displayed when the Budget Year option
is selected from the TABLE menu. It allows you to change the default
budget year.
Budget year - The current budget year.
F1-Help F2-Pick List F10-Process Esc-Exit
▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓
▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓
▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓
▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓
▓▓▓┌─[ Budget Year ]────────────────────────────────────────────┐▓▓▓▓▓▓▓▓
▓▓▓│ │▓▓▓▓▓▓▓▓
▓▓▓│ │▓▓▓▓▓▓▓▓
▓▓▓│ Current Budget Year: 1991 │▓▓▓▓▓▓▓▓
▓▓▓│ │▓▓▓▓▓▓▓▓
▓▓▓│ │▓▓▓▓▓▓▓▓
▓▓▓│ │▓▓▓▓▓▓▓▓
▓▓▓│ │▓▓▓▓▓▓▓▓
▓▓▓└────────────────────────────────────────────────────────────┘▓▓▓▓▓▓▓▓
▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓
▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓
▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓
▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓
CHANGE BUDGET YEAR - Press the F2 key to list all valid budget year.
Select the one you required and press the ENTER key. Press the F10
key to execute.
2.3 Budget
───────────────────────────────────────────────────────────────────
The following screen will be displayed when the Budget option is
selected. The budget screen provides the following options:
Tracking - This option allows you to create entity accounts,
then entering the budget and actual data.
Export - This option allows you to export budget data to DBF files
or ascii delimited files.
Summary - This option allows you to view summarized budget by month,
quarter or year.
F6-Tracking F7-Export F8-Import F9-Summary
▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓
▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓
▓▓╒═ [ Entities ] ════════════════════════════[ 1 of 3 ]══╕▓▓▓▓▓▓▓▓▓▓▓▓▓
▓▓│ID NAME │▓▓▓▓▓▓▓▓▓▓▓▓▓
▓▓│═══════════════╤═════════════════════════════════════════│▓▓▓▓▓▓▓▓▓▓▓▓▓
▓▓│101 │ Computer Science Department │▓▓▓▓▓▓▓▓▓▓▓▓▓
▓▓│201 │ Engineering Department │▓▓▓▓▓▓▓▓▓▓▓▓▓
▓▓│301 │ Business Department │▓▓▓▓▓▓▓▓▓▓▓▓▓
▓▓│ │ │▓▓▓▓▓▓▓▓▓▓▓▓▓
▓▓│ │ │▓▓▓▓▓▓▓▓▓▓▓▓▓
▓▓╘═══════════════╧═════════════════════════════════════════╛▓▓▓▓▓▓▓▓▓▓▓▓▓
▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓
▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓
▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓
▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓
F1-Help <Esc>Exit
To select the option, press the designated hotkey for that option. For
example, press F7 key to execute the Export option.
2.3.1 Tracking
___________________________________________________________________
This menu item provides two options. The Yearly budget option will
bring up the yearly budget screen for yearly budget preparation. The
Monthly Budget option will bring up the monthly budget screen for
monthly budget preparations.
F6-Tracking F7-Export F8-Import F9-Summary
▓╔═══════════════════════════════════════════╗▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓
▓║1. Yearly budgets ║ ▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓
▓║2. Monthly budgets ║ 1 of 6 ]══╕▓▓▓▓▓▓▓▓▓▓▓▓▓
▓╚═══════════════════════════════════════════╝ │▓▓▓▓▓▓▓▓▓▓▓▓▓
▓ ═════════════│▓▓▓▓▓▓▓▓▓▓▓▓▓
▓▓│101 │ Computer Science Department │▓▓▓▓▓▓▓▓▓▓▓▓▓
▓▓│201 │ Engineering Department │▓▓▓▓▓▓▓▓▓▓▓▓▓
▓▓│301 │ Business Department │▓▓▓▓▓▓▓▓▓▓▓▓▓
▓▓│991 │ Information Systems │▓▓▓▓▓▓▓▓▓▓▓▓▓
▓▓│992 │ Human Resources Department │▓▓▓▓▓▓▓▓▓▓▓▓▓
▓▓│993 │ Finance Department │▓▓▓▓▓▓▓■▓▓▓▓▓
▓▓│ │ │▓▓▓▓▓▓▓▓▓▓▓▓▓
▓▓╘═══════════════╧═════════════════════════════════════════╛▓▓▓▓▓▓▓▓▓▓▓▓▓
▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓
▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓
2.3.1.1 Yearly Budgets
───────────────────────────────────────────────────────────────────
Select the Yearly Budget option to display the following screen.
This screen allows you to create entity accounts, and then entering
the budget and actual data.
The upper block of the screen displays the entity's yearly budget
summary.
The lower block of the screen displays the entity's accounts,
associated with yearly budget, yearly actual.
F2-Account F7-Enter Budget F8-Enter Actual
▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓
▓▓┌────────────[ Entity: 101 Computer Science Department ]────────────┐▓▓▓▓
▓▓│ Year 1992: Budget Actual Variance │▓▓▓▓
▓▓│ Total Revenues: 204,000 30,000 -174,000 │▓▓▓▓
▓▓│ Total Expenses: 51,600 0 -51,600 │▓▓▓▓
▓▓│ Net Income: 152,400 30,000 -122,400 │▓▓▓▓
▓▓└───────────────────────────────────────────────────────────────────┘▓▓▓▓
▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓
▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓
▓▓╒═ [ Yearly Budgets ]═════════════════════════════════[ 1 of 8 ]═╕▓▓
▓▓│ Account Budget Actual │▓▓
▓▓│ Account Description Ty YR YR │▓▓
▓▓│═══════════╤════════════════════════╤════╤═════════════╤═════════════│▓▓
▓▓│ 401 │ Tuition Fee │ R │ 180,000 │ 30,000 │▓▓
▓▓│ 402 │ Lab Fee │ R │ 12,000 │ 0 │▓▓
▓▓│ 403 │ Book Fee │ R │ 12,000 │ 0 │▓▓
▓▓│ 5011 │ Salary - Full Time │ E │ 36,000 │ 0 │▓▓
▓▓│ 5012 │ Salary - Wages │ E │ 12,000 │ 0 │▓▓
▓▓│ 502 │ Office Supplies │ E │ 1,200 │ 0 │▓▓
▓▓│ 503 │ Telephone │ E │ 1,200 │ 0 │▓▓
▓▓│ 504 │ Insurance │ E │ 1,200 │ 0 │▓▓
▓▓╘═══════════╧════════════════════════╧════╧═════════════╧═════════════╛▓▓
▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓
F1-Help <Alt-K>Copy Budget F5-Toggle <Esc>Exit
To select an option, press the designated hotkey for that option. For
example, press F7 key to execute the Enter Budget option.
ADDING ENTITY ACCOUNTS - press F3 key to display the following screen.
This screen allows you to toggle the select field. If the select field
indicates an "X", that means the account already existed, otherwise
set the Select field to "Y" and the press F10 key to process.
<Enter>Toggle One <F3>Toggle All F10-Process Update <Esc>Exit
▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓
▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓
▓▓▓▓▓╒═ [ Account ] ══════════════════════════════════════════════════╕▓▓▓▓
▓▓▓▓▓│Account Description Type Select │▓▓▓▓
▓▓▓▓▓│══════════╤═══════════════════════════╤══════╤══════════════════│▓▓▓▓
▓▓▓▓▓│401 │ Tuition Fee │ R │ N │▓▓▓▓
▓▓▓▓▓│402 │ Lab Fee │ R │ N │▓▓▓▓
▓▓▓▓▓│403 │ Book Fee │ R │ N │▓▓▓▓
▓▓▓▓▓│5011 │ Salary - Full Time │ E │ N │▓▓▓▓
▓▓▓▓▓│5012 │ Salary - Wages │ E │ N │▓▓▓▓
▓▓▓▓▓│502 │ Office Supplies │ E │ N │▓▓▓▓
▓▓▓▓▓│503 │ Telephone │ E │ N │▓▓▓▓
▓▓▓▓▓│504 │ Insurance │ E │ N │▓▓▓▓
▓▓▓▓▓╘══════════╧═══════════════════════════╧══════╧══════════════════╛▓▓▓▓
▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓
▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓
COPYING BUDGET DATA - Press Alt-K to pop up the following screen.
Enter the budget year, entity and type and then press the Enter key to
process.
▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓
▓▓┌──────────────────────────────────────────┐▓▓▓
▓▓│ │▓▓▓
▓▓│ Budget Year : 1992 │▓▓▓
▓▓│ Entity : │▓▓▓
▓▓│ Type (Actual/Budget) : B │▓▓▓
▓▓│ │▓▓▓
▓▓└──────────────────────────────────────────┘▓▓▓
▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓
DELETING ENTITY ACCOUNTS - move the cursor to the entity account
that you want to delete. Press the F4 key to remove the record from
the system.
2.3.1.1 Entering Budget
────────────────────────────────────────────────────────────────────
Press the F7 key on the Budget screen to display the following screen.
This screen allows you to distribute amounts into periods. You can
select different method to distribute budgets.
The upper block of the screen displays the budget year, entity name
and account name.
The lower block of the screen displays the previous year and
current year's budgets and actuals.
F1-Help F2-Distribution Methods F10-Process Update Esc-Exit
▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓
▓▓▓▓▓▓▓ Budget Year: 1991 ▓▓▓▓▓▓▓▓▓
▓▓▓▓▓▓▓ Entity : 991 Information Systems ▓▓▓▓▓▓▓▓▓
▓▓▓▓▓▓▓ Account : 5001 Salary ▓▓▓▓▓▓▓▓▓
▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓
▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓
▓▓╒═[ Budget Distribution ]════════════════════════════════[ 1 of 12 ]═╕▓▓
▓▓│Period Actual 1989 Actual 1990 Budget 1990 Budget 1991 │▓▓
▓▓│═══════╤═══════════════╤═══════════════╤═══════════════╤═════════════│▓▓
▓▓│01 │ 0.00 │ 0.00 │ 0.00 │ 3000.00 │▓▓
▓▓│02 │ 0.00 │ 0.00 │ 0.00 │ 3000.00 │▓▓
▓▓│03 │ 0.00 │ 0.00 │ 0.00 │ 3000.00 │▓▓
▓▓│04 │ 0.00 │ 0.00 │ 0.00 │ 3000.00 │▓▓
▓▓│05 │ 0.00 │ 0.00 │ 0.00 │ 3000.00 │▓▓
▓▓│06 │ 0.00 │ 0.00 │ 0.00 │ 3000.00 │▓▓
▓▓│07 │ 0.00 │ 0.00 │ 0.00 │ 3000.00 │▓▓
▓▓│08 │ 0.00 │ 0.00 │ 0.00 │ 3000.00 │▓▓
▓▓│09 │ 0.00 │ 0.00 │ 0.00 │ 3000.00 │▓▓
▓▓│10 │ 0.00 │ 0.00 │ 0.00 │ 3000.00 │▓▓
▓▓│11 │ 0.00 │ 0.00 │ 0.00 │ 3000.00 │▓▓
▓▓│12 │ 0.00 │ 0.00 │ 0.00 │ 3000.00 │▓▓
▓▓│═══════╧═══════════════╧═══════════════╧═══════════════╧═════════════│▓▓
▓▓│Total= 0.00 0.00 0.00 36000.00 │▓▓
▓▓╘═════════════════════════════════════════════════════════════════════╛▓▓
EDITING BUDGET DATA - move the cursor to the field where you want to
edit, type in the amount and press the Enter key.
Distribution Methods
────────────────────────────────────────────────────────────────────
Press the F2 key on the Budget screen to display the following options.
Position the cursor on the method that you wish to select and press
the Enter key.
F1-Help F2-Distribution Methods F10-Process Update Esc-Exit
▓▓▓▓▓▓▓▓▓▓▓┌─────────────────────────┐▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓
▓▓▓▓▓▓▓▓▓▓▓│ Constant │▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓
▓▓▓▓▓▓▓▓▓▓▓│ % Growth │▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓
▓▓▓▓▓▓▓▓▓▓▓│ Increment │▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓
▓▓▓▓▓▓▓▓▓▓▓│ Copying │▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓
▓▓▓▓▓▓▓▓▓▓▓└─────────────────────────┘▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓
▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓
EDIT WITH THE CONSTANT OPTION - This method allows you enter a constant
value and the system will then assign that constant value to each
of the 12 periods.
▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓
▓┌───────────────────┐▓
▓│Period 91 Budget│▓
▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓ ▓│ 01 1,000 │▓
▓┌─[ Constant ]───────────┐▓ ▓│ 02 1,000 │▓
▓│ │▓ Result ▓│ 03 1,000 │▓
▓│ Constant: 1000.00 ├▓──────────────> ▓│ 04 1,000 │▓
▓│ │▓ ▓│ 05 1,000 │▓
▓└────────────────────────┘▓ ▓│ 06 1,000 │▓
▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓ ▓│ 07 1,000 │▓
▓│ 08 1,000 │▓
▓│ 09 1,000 │▓
▓│ 10 1,000 │▓
▓│ 11 1,000 │▓
▓│ 12 1,000 │▓
▓└───────────────────┘▓
▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓
EDIT WITH THE % GROWTH OPTION - This method calculates the percentage
of growth of each period. You will be required to enter the base value
and the percentage.
▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓
▓┌────────────────────────┐▓
▓│ Period Budget │▓
▓├────────────────────────┤▓
▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓ ▓│ 01 1,000 │▓
▓┌─[ % Growth ]───────────┐▓ ▓│ 02 1,000+100=1,100 │▓
▓│ │▓ ▓│ 03 1,100+100=1,200 │▓
▓│ Base Value: 1000 │▓ Result ▓│ 04 1,200+100=1,300 │▓
▓│ │▓──────────>▓│ 05 1,300+100=1,400 │▓
▓│ Percentage: 10 % │▓ ▓│ 06 1,400+100=1,500 │▓
▓│ │▓ ▓│ 07 1,500+100=1,600 │▓
▓└────────────────────────┘▓ ▓│ 08 1,600+100=1,700 │▓
▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓ ▓│ 09 1,700+100=1,800 │▓
▓│ 10 1,800+100=1,900 │▓
▓│ 11 1,900+100=2,000 │▓
▓│ 12 2,000+100=2,100 │▓
▓└────────────────────────┘▓
▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓
EDIT WITH THE INCREMENT OPTION - This method calculates the increment
value of each period. You will be required to enter the base value and
the increment.
▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓
▓┌────────────────────────┐▓
▓│Period Budget │▓
▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓ ▓├────────────────────────│▓
▓┌─[ Increment ]────────────┐▓▓ ▓│ 01 1,000 │▓
▓│ │▓▓ ▓│ 02 1,000+100=1,100 │▓
▓│ Base value: 1000.00 │▓▓ ▓│ 03 1,100+100=1,200 │▓
▓│ │▓▓Result ▓│ 04 1,200+100=1,300 │▓
▓│ Increment: 100.00 │▓▓────────> ▓│ 05 1,300+100=1,400 │▓
▓│ │▓▓ ▓│ 06 1,400+100=1,500 │▓
▓│ │▓▓ ▓│ 07 1,500+100=1,600 │▓
▓└──────────────────────────┴▓▓ ▓│ 08 1,600+100=1,700 │▓
▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓ ▓│ 09 1,700+100=1,800 │▓
▓│ 10 1,800+100=1,900 │▓
▓│ 11 1,900+100=2,000 │▓
▓│ 12 2,000+100=2,100 │▓
▓└────────────────────────┘▓
▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓
COPYING OPTION - This option allows you to copy the budget distribution
data from previous year budget or actual with the percentage increase.
▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓
▓┌─────────────────────┐▓
▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓ ▓│ 89 Budget 91 Budget│▓
▓┌─[ Copying ]──────────────┐▓▓ ▓│ 1,000 1,000 │▓
▓│ │▓▓ ▓│ 1,500 1,500 │▓
▓│ Copying from Year : 1991 │▓▓ Result ▓│ 2,000 2,000 │▓
▓│ Type (Budget/Actual) : B │▓▓──────────> ▓│ 2,000 2,000 │▓
▓│ Percent Increase (%) : 0 │▓▓ ▓│ 3,000 3,000 │▓
▓└──────────────────────────┘▓▓ ▓│ 3,000 3,000 │▓
▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓ ▓│ 3,000 3,000 │▓
▓│ 4,000 4,000 │▓
▓│ 4,000 4,000 │▓
▓│ 4,000 4,000 │▓
▓│ 4,000 4,000 │▓
▓│ 5,000 5,000 │▓
▓└─────────────────────┘▓
▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓
2.3.1.2 Entering Actual
───────────────────────────────────────────────────────────────────
Press the F8 key on the Budget screen to display the following screen.
This screen allows you to browse and edit the daily transactions data.
The upper block of the screen displays budget year, entity and entity
account. The lower block of the screen lists the entity-account's
transaction records. Each record consists of the following data
elements:
Date - The date of the transaction.
Description - The description of the transaction item.
Actual - The actual amount of the transaction.
Commitment - The commitment of the transaction.
Ref - The reference of the transaction.
F1-Help <Enter>Edit F3-Add F4-Delete F5-Toggle Esc-Exit
▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓
▓▓ ▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓
▓▓ Budget Year: 1992 ▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓
▓▓ Entity: 101 Computer Science Department ▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓
▓▓ Account: 5011 Salary - Full Time ▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓
▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓
▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓
▓▓╒═[ Daily Actual ]═════════════════════════════════════[ 1 of 2 ]══╕▓▓▓
▓▓│Date DESCRIPTION Actual │▓▓▓
▓▓│═════════╤══════════════════════════════════════╤═══════════════════│▓▓▓
▓▓│01/01/92 │ Salary for Full-Time Instructors │ 3000.00 │▓▓▓
▓▓│02/01/92 │ Salary for Full-Time Instructors │ 3000.00 │▓▓▓
▓▓│ │ │ │▓▓▓
▓▓│ │ │ │▓▓▓
▓▓│ │ │ │▓▓▓
▓▓│ │ │ │▓▓▓
▓▓│ │ │ │▓▓▓
▓▓│ │ │ │▓▓▓
▓▓│ │ │ │▓▓▓
▓▓│ │ │ │▓▓▓
▓▓╘═════════╧══════════════════════════════════════╧═══════════════════╛▓▓▓
▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓
▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓
ADDING TRANSACTION RECORD - move the cursor to the row where you
wish to add the record and press the F3 key. The system will insert a
blank row below the selected row and position the cursor to the date
field. Enter the date and press the ENTER key. If the date is valid, then
the new transaction record will be added into the transaction table.
DELETING TRANSACTION RECORD - move the cursor to the record that you
wish to delete and press the F4 key to remove the record from the
system.
EDITING TRANSACTION RECORD - move the cursor to the field where you wish
to edit and press the Enter key to invoke to edit mode. Edit the field
and press Enter key again to return to the display mode.
PRINT TRANSACTION REPORT - Press F9 key to print a hard copy of
daily transactions report.
DATE: 02/01/92 Daily Transactions Report Page: 1
Date Account Transaction Actual Commitment Ref.
__________________________________________________________________________
Entity: 101 Computer Science Department
01/01/92 5011 Salary of Full-Time Instructors 3,000.00 0 101
02/01/92 5011 Salary of Full-Time Instructors 3,000.00 0 102
SINGLE DAILY TRANSACTION RECORD SCREEN - Press F5 key to display the
single record screen. It allows you to add, change, delete the daily
transaction record.
F1-Help F3-Add F4-Delete F5-Toggle Esc-Exit
▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓
▓▓ ▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓
▓▓ Budget Year:1992 ▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓
▓▓ Entity: 101 Computer Science Department ▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓
▓▓ Account: 401 Tuition Fee ▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓
▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓
▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓
▓▓┌─ [ Daily Actuals ] ──────────────────────────────────[ 1 of 3 ]─┐▓▓▓
▓▓│ │▓▓▓
▓▓│ Date: 01/01/92 │▓▓▓
▓▓│ Description: Tuition Fee (JAN) │▓▓▓
▓▓│ Amount: 10000.00 │▓▓▓
▓▓│ Commitment: 0.00 │▓▓▓
▓▓│ Ref. No: │▓▓▓
▓▓│ │▓▓▓
▓▓└───────────────────────────────────────────────────────────────────┘▓▓▓
▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓
▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓
TAB-Next Field PgUp-Prev Record PgDn-Next Record
Hotkey Functions:
F1-Help - Display Help screen
F3-Add - Add new daily transaction record
F4-Delete - Delete selected daily transaction record
F5-Toggle - Switch back to browse screen
Esc-Exit - Exit this screen
2.3.1.2 Monthly Budgets
───────────────────────────────────────────────────────────────────────
Select Monthly Budget option from the Tracking menu item to display the
following screen. The top block displays the monthly totals of revenses
and expenses. The bottom block displays the monthly budget vs actual
of each entity acocunt.
F2-Account F8-Enter Actual F9-Print
▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓
▓▓┌────────────[ Entity: 101 Computer Science Department ]────────────┐▓▓▓▓
▓▓│ Period: 8 Budget Actual Variance │▓▓▓▓
▓▓│ Total Revenues: 47,000 3,500 -43,500 │▓▓▓▓
▓▓│ Total Expenses: 4,300 6,100 1,800 │▓▓▓▓
▓▓│ Net Income: 42,700 -2,600 -45,300 │▓▓▓▓
▓▓└───────────────────────────────────────────────────────────────────┘▓▓▓▓
▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓
▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓
▓▓╒═ [ Monthly Budgets ]═══════════════════════════════════[ 1 of 8 ]═╕▓▓
▓▓│ Account Monthly Monthly │▓▓
▓▓│ Account Description Ty Budget Actual │▓▓
▓▓│════════════════╤═══════════════════╤════╤═════════════╤═════════════│▓▓
▓▓│ 401 │ Tuition Fee │ R │ 45,000 │ 2,000 │▓▓
▓▓│ 402 │ Lab Fee │ R │ 1,000 │ 500 │▓▓
▓▓│ 403 │ Book Fee │ R │ 1,000 │ 1,000 │▓▓
▓▓│ 5011 │ Salary - Full Time│ E │ 3,000 │ 2,000 │▓▓
▓▓│ 5012 │ Salary - Wages │ E │ 1,000 │ 1,000 │▓▓
▓▓│ 502 │ Office Supplies │ E │ 100 │ 2,000 │▓▓
▓▓│ 503 │ Telephone │ E │ 100 │ 100 │▓▓
▓▓│ 504 │ Insurance │ E │ 100 │ 1,000 │▓▓
▓▓╘════════════════╧═══════════════════╧════╧═════════════╧═════════════╛▓▓
▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓
Keys: F1-Help, Esc=Exit, Up, Down, Left, Right, PgDn, PgUp
FUNCTIONS:
ADDING ACCOUNTS - Press F3 key and the system will pop up a listing of
of all accounts for selection. Select the accounts that you want to add
and press F10 key to process.
DELETING ACCOUNTS - Move the cursor to the account that you wish to
delete and press F4 key to remove the record.
EDIT BUDGET - Move the cursor to the budget column that you wish to
edit, type in the change and press the Enter key.
ENTER ACTUAL - Press F7 to pop up the option menu. Option 1 allows you
to view and edit the existing actual data. Option 2 will set up a set
of default transactions for data entry.
PRINT REPORT - Press F9 key to print a hard copy of monthly budget
vs actual report.
2.3.2.2.1 View/Edit Actuals
──────────────────────────────────────────────────────────────────────────
Select option 1 from the Enter Actual menu item to display the following
screen. Thes screen allows you to add, change and delete daily transaction
records.
Enter-Edit F3-Add F4-Delete F9-Print Esc-Exit
▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓
▓▓ ▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓
▓▓ Budget Year:1992 ▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓
▓▓ Entity: 101 Computer Science Department ▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓
▓▓ Period: 1 ▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓
▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓
▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓
▓▓╒═[ Daily Actuals ]═════════════════════════════════════════[ 1 of 6 ]══╕▓▓▓
▓▓│ Date │▓▓▓
▓▓│ Account mm/dd/yy Actual DESCRIPTION │▓▓▓
▓▓│═════════════════╤══════════╤══════════════╤═════════════════════════════│▓▓▓
▓▓│ 401 │ 01/01/92 │ 10000.00 │ Tuition Fee (JAN) │▓▓▓
▓▓│ 5011 │ 01/01/92 │ 3000.00 │ Salary for Instructors (J │▓▓▓
▓▓│ 5012 │ 01/01/92 │ 500.00 │ Part-Time Instructors (JA │▓▓▓
▓▓│ 502 │ 01/01/92 │ 80.00 │ Office Supplies │▓▓▓
▓▓│ 503 │ 01/01/92 │ 50.00 │ Telephone (JAN) │▓▓▓
▓▓│ 504 │ 01/01/92 │ 100.00 │ Insurance │▓▓▓
▓▓│ │ │ │ │▓▓▓
▓▓│ │ │ │ │▓▓▓
▓▓│ │ │ │ │▓▓▓
▓▓╘═════════════════╧══════════╧══════════════╧═════════════════════════════╛▓▓▓
▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓
▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓
FUNCTIONS:
ADDING RECORD - Press F3 key to create blank record. Then enter acocunt,
date, actual, description, commitment and ref.
EDITING RECORD - Simply move the cursor to field where you wish to edit,
type in the change and press Enter key.
DELETE RECORD - Move the cursor to the record that you wish to delete and
press F4 key to remove the record.
PRINTING - Press F9 key to print a hard copy of the daily transaction
report.
2.3.2.2.2 Default Transactions
─────────────────────────────────────────────────────────────────────────
Select option 2 from the Enter Actual menu item to display the following
screen. This screen creates a set of default transactions so that all
you have to do is to enter the actuals.
Enter-Edit F10-Process Esc-Exit F1-Help PgUp PgDn
▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓
▓▓ ▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓
▓▓ Budget Year:1992 ▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓
▓▓ Entity: 101 Computer Science Department ▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓
▓▓ Period: 1 ▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓
▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓
▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓
▓▓╒═[ Daily Actuals ]════════════════════════════════════[ 1 of 8 ]══╕▓▓▓
▓▓│ Date │▓▓▓
▓▓│ Account mm/dd/yy Actual DESCRIPTION │▓▓▓
▓▓│═════════════════╤══════════╤══════════════╤════════════════════════│▓▓▓
▓▓│ 401 │ 08/03/92 │ 0 │ │▓▓▓
▓▓│ 402 │ 08/03/92 │ 0 │ │▓▓▓
▓▓│ 403 │ 08/03/92 │ 0 │ │▓▓▓
▓▓│ 5011 │ 08/03/92 │ 0 │ │▓▓▓
▓▓│ 5012 │ 08/03/92 │ 0 │ │▓▓▓
▓▓│ 502 │ 08/03/92 │ 0 │ │▓▓▓
▓▓│ 503 │ 08/03/92 │ 0 │ │▓▓▓
▓▓│ 504 │ 08/03/92 │ 0 │ │▓▓▓
▓▓│ │ │ │ │▓▓▓
▓▓╘═════════════════╧══════════╧══════════════╧════════════════════════╛▓▓▓
▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓
▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓
Tuition Fee
ENTERING ACTUAL - Enter the actuals and press F10 key to process. Only
the non-zero actual amount records will be processed.
2.3.2 ONLINE BUDGET SUMMARY
────────────────────────────────────────────────────────────────────────
Press F9 key on the Entity Budget Screen to display the following
screen. It provides the following options:
MONTHLY BUDGET VS ACTUAL - This option lists the budget, actual,
variance, revised projection of each month.
QUARTERLY BUDGET VS ACTUAL - This option lists the budget, actual,
variance, revised projection of each quarter.
YEARLY BUDGET VS ACTUAL - This option lists the yearly total of budget,
actual and variance.
F6-Entity-Budget F7-Export F8-Import F9-Summary
▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓╔════════════════════════════════════════════╗▓▓▓▓
▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓║1. Monthly Budget vs Actual ║ ▓▓▓
▓▓╒═ [ Entities ] ══════║2. Quarterly Budget vs Actual ║ ▓▓▓
▓▓│ID ║3. Yearly Budget vs Actual ║ ▓▓▓
▓▓│═══════════════╤═════╚════════════════════════════════════════════╝ ▓▓▓
▓▓│101 │ Computer Department ▓▓▓
▓▓│201 │ Engineering Department │▓▓▓▓▓▓▓▓▓▓▓▓▓
▓▓│301 │ Business Department │▓▓▓▓▓▓▓▓▓▓▓▓▓
▓▓│991 │ Information Systems │▓▓▓▓▓▓▓▓▓▓▓▓▓
▓▓│992 │ Human Resources Department │▓▓▓▓▓▓▓▓▓▓▓▓▓
▓▓│993 │ Finance Department │▓▓▓▓▓▓▓▓▓▓▓▓▓
▓▓│ │ │▓▓▓▓▓▓▓▓▓▓▓▓▓
▓▓│ │ │▓▓▓▓▓▓▓▓▓▓▓▓▓
▓▓│ │ │▓▓▓▓▓▓▓▓▓▓▓▓▓
▓▓╘═══════════════╧═════════════════════════════════════════╛▓▓▓▓▓▓▓▓▓▓▓▓▓
▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓
▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓
F1-Help <Esc>Exit
To select an option, simply move the cursor key to the option you want
and press the Enter key to execute that option. The system will then
display the selected entity, you can change the entity if necessary or
else press the Enter key to process.
2.3.2.1 SUMMARY - Monthly Budget vs Actual
────────────────────────────────────────────────────────────────────────
Select "1. Monthly Budget vs Actual" to display the following
screen. This screen provides the following options:
One Entity - This option allows you to print the single entity
summary report by month.
Group Entities - This option allows you to print group summary
report by month.
ALL Entities - This option allows you to print the overall summary
report by month.
Enter-Edit F8-One Entity F9-Group Entities F10-All Entities
▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓
▓┌────────[ Monthly Budget vs Actual ] ──────────────────────────┐▓▓▓▓▓▓▓▓▓
▓│ │▓▓▓▓▓▓▓▓▓
▓│This screen provides options to view Single, Group or │▓▓▓▓▓▓▓▓▓
▓│Overall Summary. For group summary, you must assign a │▓▓▓▓▓▓▓▓▓
▓│Group Id to the entities before processing. │▓▓▓▓▓▓▓▓▓
▓└───────────────────────────────────────────────────────────────┘▓▓▓▓▓▓▓▓▓
▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓
▓╒═[ Entities ]══════════════════════════════════════════[ 1 of 6 ]═╕▓▓▓▓
▓│ID NAME GROUP │▓▓▓▓
▓│═══════════════╤═════════════════════════════════════╤══════════════│▓▓▓▓
▓│101 │ Computer Science Department │ ACAD │▓▓▓▓
▓│201 │ Engineering Department │ ACAD │▓▓▓▓
▓│301 │ Business Department │ ACAD │▓▓▓▓
▓│991 │ Information Systems │ ADMN │▓▓▓▓
▓│992 │ Human Resources Department │ ADMN │▓▓▓▓
▓│993 │ Finance Department │ ADMN │▓▓▓▓
▓│ │ │ │▓▓▓▓
▓│ │ │ │▓▓▓▓
▓│ │ │ │▓▓▓▓
▓╘═══════════════╧═════════════════════════════════════╧══════════════╛▓▓▓▓
▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓
▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓
F1-Help Esc-Exit
The monthly budget vs actual screen displays the following columns
of each budgeting period.
Budget MON - Monthly Budget
Actual MON - Monthly Actual
Variance MON - Monthly Actual - Monthly Budget
Budget YTD - Year-to-Date Budget
Actual YTD - Year-to-Date Actual
Variance YTD - YTD Actual - YTD Budget
Revised Projection - YTD actual + Remaining Budget
This screen displays the first 4 columns. You can use the left-arrow key
to browse through the remaining columns on the right.
F1-Help F5-Toggle F9-Print <Esc>Exit
▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓
▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓
▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓
▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓
▓▓╒═ [ 101 Computer Science Department ] ═══════════[ row 1 of 12 ]═══╕▓▓
▓▓│ Budget │▓▓
▓▓│Account Description Type Mon(01) │▓▓
▓▓│═══════════════╤═════════════════════════╤══════╤════════════════════│▓▓
▓▓│1 │ Net Income │ T │ 7,700 │▓▓
▓▓│4 │ Revenues │ R │ 12,000 │▓▓
▓▓│401 │ Tuition Fee │ R │ 10,000 │▓▓
▓▓│402 │ Lab Fee │ R │ 1,000 │▓▓
▓▓│403 │ Book Fee │ R │ 1,000 │▓▓
▓▓│5 │ Expenses │ E │ 4,300 │▓▓
▓▓│501 │ Salary │ E │ 4,000 │▓▓
▓▓│5011 │ Salary - Full Time │ E │ 3,000 │▓▓
▓▓│5012 │ Salary - Wages │ E │ 1,000 │▓▓
▓▓│502 │ Office Supplies │ E │ 100 │▓▓
▓▓│503 │ Telephone │ E │ 100 │▓▓
▓▓╘═══════════════╧═════════════════════════╧══════╧[ Col 2 of 91 ]═══╛▓▓
▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓
▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓
▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓
▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓
PRINTING MONTHLY BUDGET REPORT - Press F9 from the Monthly Budget Summary
screen to display the following parameter screen. Enter the parameters
and press Enter key to execute.
▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓
▓▓ ┌─ [ Monthly Budget vs Summary Report ] ───────┐▓▓
▓▓ │ │▓▓
▓▓ │ Start-Period : 01 │▓▓
▓▓ │ End-Period : 12 │▓▓
▓▓ │ │▓▓
▓▓ └──────────────────────────────────────────────┘▓▓
▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓
Monthly Budget vs Actual Report
1992
Budget Actual Variance Variance Budget Revised
Period Description MON MON MON % YTD Projection
_______________________________________________________________________________
Entity : 01 Computer Science
Period : 01
1 Net Income 12,700 6,270 -6,430 -60.63 12,700 145,970
4 Revenue 17,000 10,000 -7,000 -41.18 17,000 197,000
401 Tuition Fee 15,000 10,000 -5,000 -33.33 15,000 175,000
402 Lab Fee 1,000 0 -1,000 0 1,000 11,000
403 Book Fee 1,000 0 -1,000 0 1,000 11,000
5 Expenses 4,300 3,730 -570 -13.26 4,300 51,030
501 Salary 4,000 3,500 -500 -12.50 4,000 47,500
5011 Salary - Full Time 3,000 3,000 0 0.00 3,000 36,000
5012 Salary - Wages 1,000 500 -500 -50.00 1,000 11,500
502 Office Supplies 100 80 -20 -20.00 100 1,180
503 Telephone 100 50 -50 -50.00 100 1,150
504 Insurance 100 100 0 0.00 100 1,200
2.3.2.2 SUMMARY - Quarterly Budget vs Actual
─────────────────────────────────────────────────────────────────────
Select "2. Quarterly Budget vs Actual" to display the following screen.
It provides the following options:
Single Entity - This option allows you to print the summary report
of one entity by quarter.
Group Entities - This option allows you to print a summary report
of a selected group entities by quarter.
ALL Entities - This option allows you to print the overall summary
report by quarter.
Enter-Edit F8-One Entity F9-Group Entities F10-All Entities
▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓
▓┌────────[ Monthly Budget vs Actual ] ──────────────────────────┐▓▓▓▓▓▓▓▓▓
▓│ │▓▓▓▓▓▓▓▓▓
▓│This screen provides options to view Single, Group or │▓▓▓▓▓▓▓▓▓
▓│Overall Summary. For group summary, you must assign a │▓▓▓▓▓▓▓▓▓
▓│Group Id to the entities before processing. │▓▓▓▓▓▓▓▓▓
▓└───────────────────────────────────────────────────────────────┘▓▓▓▓▓▓▓▓▓
▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓
▓╒═[ Entities ]══════════════════════════════════════════[ 1 of 6 ]═╕▓▓▓▓
▓│ID NAME GROUP │▓▓▓▓
▓│═══════════════╤═════════════════════════════════════╤══════════════│▓▓▓▓
▓│101 │ Computer Science Department │ ACAD │▓▓▓▓
▓│201 │ Engineering Department │ ACAD │▓▓▓▓
▓│301 │ Business Department │ ACAD │▓▓▓▓
▓│991 │ Information Systems │ ADMN │▓▓▓▓
▓│992 │ Human Resources Department │ ADMN │▓▓▓▓
▓│993 │ Finance Department │ ADMN │▓▓▓▓
▓│ │ │ │▓▓▓▓
▓│ │ │ │▓▓▓▓
▓│ │ │ │▓▓▓▓
▓╘═══════════════╧═════════════════════════════════════╧══════════════╛▓▓▓▓
▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓
▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓
F1-Help Esc-Exit
EDITING GROUP ID - Move the cursor to the group where you wish to edit
and press Enter key. Enter the changes and then press Enter key again.
VIEWING SUMMARY REPORT - Press the hotkey (i.e. F8 key for one entity)
to display the summary report.
The "Quarterly Budget vs Actual" screen displays the following
following columns of each quarter period.
Budget QTR - Quarterly Budget
Actual QTR - Quarterly Actual
Variance QTR - QTR Actual - QTR budget
Budget YTD - Year-to-Date Budget of that Quarter
Actual YTD - Year-to-Date Actual of that Quarter
Variance YTD - Actual YTD - Budget YTD
Revised Projection - YTD Actual + Remaining QTR Budget
This screen shows only the first 4 columns of the summary budget. You can
use left-arrow key to browse through the remaining columns on the right.
F1-Help F5-Toggle F9-Print <Esc>Exit
▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓
▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓
▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓
▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓
▓▓╒═ [ 101 Computer Science Department ] ═══════════[ row 1 of 12 ]═══╕▓▓▓
▓▓│ Budget │▓▓▓
▓▓│Account Description Type Qtr(01) │▓▓▓
▓▓│═══════════════╤═════════════════════════╤══════╤════════════════════│▓▓▓
▓▓│1 │ Net Income │ T │ 23,100 │▓▓▓
▓▓│4 │ Revenues │ R │ 36,000 │▓▓▓
▓▓│401 │ Tuition Fee │ R │ 30,000 │▓▓▓
▓▓│402 │ Lab Fee │ R │ 3,000 │▓▓▓
▓▓│403 │ Book Fee │ R │ 3,000 │▓▓▓
▓▓│5 │ Expenses │ E │ 12,900 │▓▓▓
▓▓│501 │ Salary │ E │ 12,000 │▓▓▓
▓▓│5011 │ Salary - Full Time │ E │ 9,000 │▓▓▓
▓▓│5012 │ Salary - Wages │ E │ 3,000 │▓▓▓
▓▓│502 │ Office Supplies │ E │ 300 │▓▓▓
▓▓│503 │ Telephone │ E │ 300 │▓▓▓
▓▓╘═══════════════╧═════════════════════════╧══════╧[ col 2 of 34 ]═══╛▓▓▓
▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓
▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓
▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓
▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓
To select an option, press the designated hotkey to execute that option.
For example, press F9 key to execute the Print option.
PRINTING QUARTERLY BUDGET VS ACTUAL REPORT - Press F9 key on the Quarterly
Budget vs Actual screen to display the following parameter screen, enter
the parameters and press Enter key to execute.
▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓
▓▓┌─[Quarterly Budget vs Actual Report ]───┐▓▓
▓▓│ │▓▓
▓▓│ Start-Quarter: 1 │▓▓
▓▓│ End-Quarter: 4 │▓▓
▓▓│ │▓▓
▓▓└────────────────────────────────────────┘▓▓
▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓
REPORT SAMPLE:
Quarter Budget vs Actual Report
1992
Budget Budget Actual Actual Var Var Revised
Quarter Description QTR YTD QTR YTD QTR YTD Projection
_______________________________________________________________________________
Entity : 01 Computer Science
Quarter: 01
1 Net Income 23,100 23,100 16,260 16,260 6,840 6,840 85,560
4 Revenue 36,000 36,000 27,750 27,750 8,250 8,250 135,750
401 Tuition Fee 30,000 30,000 27,750 27,750 2,250 2,250 117,750
402 Lab Fee 3,000 3,000 0 0 3,000 3,000 9,000
403 Book Fee 3,000 3,000 0 0 3,000 3,000 9,000
5 Expenses 12,900 12,900 11,490 11,490 1,410 1,410 50,190
501 Salary 12,000 12,000 10,850 10,850 1,150 1,150 48,850
5011 Salary - Full Time 9,000 9,000 9,000 9,000 0 0 36,000
5012 Salary - Wages 3,000 3,000 1,850 1,850 0 0 10,850
502 Office Supplies 300 300 290 290 10 10 1,190
503 Telephone 300 300 250 250 50 50 1,150
504 Insurance 300 300 100 100 200 200 1,000
VIEWING QUARTERLY BUDGETED ACCOUNT - Press F5 key on the Quarterly
Budget vs Actual screen to display the following screen. It allows you
to view the following columns:
Budget QTR - Quarterly Budget
Actual QTR - Quarterly Actual
Variance QTR - Quarterly Actual - Quarterly Budget
Budget YTD - Year-to-Date Budget of that Quarter
Actual YTD - Year-to-Date Actual of that Quarter
Variance YTD - Budget YTD - Actual YTD
Revised Projection - YTD Actual + Remaining QTR Budget
This screen displays only the first 4 columns of the budget. You can use
the left-arrow key to browse through the remaining columns on the right.
F1-Help F8-Print Esc-Exit
▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓
▓▓▓ Budget Year: 1992 ▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓
▓▓▓ Name: 101 Computer Science Department ▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓
▓▓▓ Account: 1 Net Income ▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓
▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓
▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓
▓╒═[ QTR Account Budget Summary ]═══════════════════════════════════════╕▓▓
▓│ Budget Actual Variance Variance │▓▓
▓│Qtr Start Date QTR QTR QTR % │▓▓
▓│════╤═══════════════╤═══════════╤═══════════╤════════════╤════════════│▓▓
▓│01 │ 01/01/92 │ 23,100 │ 18,510 │ -4,590 │ -19.87 │▓▓
▓│02 │ 04/01/92 │ 23,100 │ 0 │ -23,100 │ 0.00 │▓▓
▓│03 │ 07/01/92 │ 23,100 │ 0 │ -23,100 │ 0.00 │▓▓
▓│04 │ 10/01/92 │ 23,100 │ 0 │ -23,100 │ 0.00 │▓▓
▓╘════╧═══════════════╧═══════════╧═══════════╧════════════╧════════════╛▓▓
▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓
▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓
▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓
▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓
2.3.2.3 SUMMARY - Yearly Budget vs Actual
─────────────────────────────────────────────────────────────────────
Select "Quarterly Budget vs Actual" option on the BUDGET screen to
display the following screen. It provides the following options:
Single Entity - This option allows you to view the budget summary
of one entity by year.
Group Entities - This option allows you to veiw the budget summary
of a selected group of entities by year.
ALL Entities - This option allows you to print the overall budget
summary.
Enter-Edit F8-One Entity F9-Group Entities F10-All Entities
▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓
▓┌────────[ Monthly Budget vs Actual ] ──────────────────────────┐▓▓▓▓▓▓▓▓▓
▓│ │▓▓▓▓▓▓▓▓▓
▓│This screen provides options to view Single, Group or │▓▓▓▓▓▓▓▓▓
▓│Overall Summary. For group summary, you must assign a │▓▓▓▓▓▓▓▓▓
▓│Group Id to the entities before processing. │▓▓▓▓▓▓▓▓▓
▓└───────────────────────────────────────────────────────────────┘▓▓▓▓▓▓▓▓▓
▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓
▓╒═[ Entities ]══════════════════════════════════════════[ 1 of 6 ]═╕▓▓▓▓
▓│ID NAME GROUP │▓▓▓▓
▓│═══════════════╤═════════════════════════════════════╤══════════════│▓▓▓▓
▓│101 │ Computer Science Department │ ACAD │▓▓▓▓
▓│201 │ Engineering Department │ ACAD │▓▓▓▓
▓│301 │ Business Department │ ACAD │▓▓▓▓
▓│991 │ Information Systems │ ADMN │▓▓▓▓
▓│992 │ Human Resources Department │ ADMN │▓▓▓▓
▓│993 │ Finance Department │ ADMN │▓▓▓▓
▓│ │ │ │▓▓▓▓
▓│ │ │ │▓▓▓▓
▓│ │ │ │▓▓▓▓
▓╘═══════════════╧═════════════════════════════════════╧══════════════╛▓▓▓▓
▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓
▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓
F1-Help Esc-Exit
EDITING GROUP ID - Move the cursor to the entity record where you wish
to edit and press Enter key, then edit the group id and press Enter key.
VIEWING SUMMARY REPORT - Press the hotkey (i.e. F8 for one entity) to
display the summary report.
The "Yearly Budget vs Actual" screen displays the following columns:
Budget (YR) - The yearly budget
Actual (YR) - The yearly actual
Variance - Yearly budget - yearly Actual
F1-Help F9-Print <Esc>Exit
▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓
▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓
▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓
▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓
▓▓╒═ [ 101 Computer Science Department ] ══════════[ row 1 of 12 ]═══╕▓▓▓
▓▓│ Budget │▓▓▓
▓▓│Account Description Type YR │▓▓▓
▓▓│═══════════════╤════════════════════════╤══════╤════════════════════│▓▓▓
▓▓│1 │ Net Income │ T │ 92,400 │▓▓▓
▓▓│4 │ Revenues │ R │ 144,000 │▓▓▓
▓▓│401 │ Tuition Fee │ R │ 120,000 │▓▓▓
▓▓│402 │ Lab Fee │ R │ 12,000 │▓▓▓
▓▓│403 │ Book Fee │ R │ 12,000 │▓▓▓
▓▓│5 │ Expenses │ E │ 51,600 │▓▓▓
▓▓│501 │ Salary │ E │ 48,000 │▓▓▓
▓▓│5011 │ Salary - Full Time │ E │ 36,000 │▓▓▓
▓▓│5012 │ Salary - Wages │ E │ 12,000 │▓▓▓
▓▓│502 │ Office Supplies │ E │ 1,200 │▓▓▓
▓▓│503 │ Telephone │ E │ 1,200 │▓▓▓
▓▓╘═══════════════╧════════════════════════╧══════╧[ col 2 of 34 ]═══╛▓▓▓
▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓
▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓
▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓
▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓
DATE: 02/01/92 Yearly Budget Report Page: 1
1992
Account Description Budget Actual Variance
--------------------------------------------------------------------
Entity: 01 Computer Science Department
1 Net Income 92,400 16,260 -76,140
4 Revenues 144,000 27,750 -116,250
401 Tuition Fee 120,000 0 -92,250
402 Lab Fee 12,000 0 -12,000
403 Book Fee 12,000 0 -12,000
5 Expenses 51,600 11,490 -40,100
501 Salary 48,000 10,850 -37,150
5011 Salary - Full Time 36,000 9,000 -27,000
5012 Salary - Wages 12,000 1,850 -10,150
502 Office Supplies 1,200 290 -910
503 Telephone 1,200 250 -950
504 Insurance 1,200 100 -1,100
2.3.3 Exporting Budget Data
───────────────────────────────────────────────────────────────────
Press F7 key on the Budget screen to display the following screen.
It provides the following options:
Option (1) Export budget data to DBF files
Option (2) Export budget data to ascii delimited files
F6-Entity-Budget F7-Export F8-Import F9-Summary
▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓╔═════════════════════════════════════════════════════╗▓▓▓▓
▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓║1. Export Budget only to DBF file ║ ▓▓▓
▓▓╒═ [ Entities ║2. Export Budget & Actual to DBF file ║ ▓▓▓
▓▓│ID ║3. Export Budget only to Ascii Delimited File ║ ▓▓▓
▓▓│═════════════║4. Export Budget & Actual to Ascii Delimited File ║ ▓▓▓
▓▓│101 ╚═════════════════════════════════════════════════════╝ ▓▓▓
▓▓│201 ▓▓▓
▓▓│301 │ Business Department │▓▓▓▓▓▓▓▓▓▓▓▓▓▓
▓▓│991 │ Information Systems │▓▓▓▓▓▓▓▓▓▓▓▓▓▓
▓▓│992 │ Human Resources Department │▓▓▓▓▓▓▓▓▓▓▓▓▓▓
▓▓│993 │ Finance Department │▓▓▓▓▓▓▓▓▓▓▓▓▓▓
▓▓│ │ │▓▓▓▓▓▓▓▓▓▓▓▓▓▓
▓▓│ │ │▓▓▓▓▓▓▓▓▓▓▓▓▓▓
▓▓│ │ │▓▓▓▓▓▓▓▓▓▓▓▓▓▓
▓▓╘═══════════════╧═════════════════════════════════════════╛▓▓▓▓▓▓▓▓▓▓▓▓▓▓
▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓
▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓
F1-Help <Esc>Exit
SELECTING EXPORT OPTION - Move the cursor to the option that you wish
to select and press the Enter key.
2.3.3.1 Export Budget to DBF files
───────────────────────────────────────────────────────────────────
Select option 1 from the Export option box to display the following
screen. Before you export budget data, you must check to make sure
all the data path are corrected so that the system knows where to
locate the output files.
PATH - a 25 character code to identify the directory and the
output file name.
Output file Format:
Budget Year char(4)
Entity Id char(14)
Account No char(14)
Budget 01 - 12 number(11,2) 12 times
Enter-Edit Path F9-Export One Entity F10-Export all entities Esc-Exit
▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓
▓┌───────────────────────────────────────────────────────────────┐▓▓▓▓▓▓▓▓
▓│ │▓▓▓▓▓▓▓▓
▓│ Warning: Be sure all data path are corrected before │▓▓▓▓▓▓▓▓
▓│ exporting budget data. │▓▓▓▓▓▓▓▓
▓│ │▓▓▓▓▓▓▓▓
▓└───────────────────────────────────────────────────────────────┘▓▓▓▓▓▓▓▓
▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓
▓╒═[ Export budget data to DBF files ]════════════════════[ 1 of 3 ]═╕▓▓
▓│ID NAME PATH │▓▓
▓│═══════════════╤═════════════════╤═══════════════════════════════════│▓▓
▓│101 │ Computer Scienc │ C:\BUDGET\92B101.DBF │▓▓
▓│201 │ Engineering Dep │ C:\BUDGET\92B201.DBF │▓▓
▓│301 │ Business Depart │ C:\BUDGET\92B301.DBF │▓▓
▓│ │ │ │▓▓
▓│ │ │ │▓▓
▓│ │ │ │▓▓
▓│ │ │ │▓▓
▓│ │ │ │▓▓
▓│ │ │ │▓▓
▓╘═══════════════╧═════════════════╧═══════════════════════════════════╛▓▓
▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓
▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓
EDITING PATH - Move the cursor to the entity record where you wish to edit
and press the Enter key. Edit the path and press the Enter key again.
Exporting one entity - Move the cursor to the entity record that you want
to export and press the F9 key.
Exporting all entities - Press the F10 key to export all entities.
2.3.3.2 Export Budget & Actual to DBF files
───────────────────────────────────────────────────────────────────
Select option 1 from the Export option box to display the following
screen. Before you export budget data, you must check to make sure
all the data path are corrected so that the system knows where to
locate the output files.
PATH - a 25 character code to identify the directory and the
output file name.
Output file Format:
Budget Year char(4)
Entity Id char(14)
Account No char(14)
Budget 01 - 12 number(11,2) 12 times
Actual 01 - 12 number(11,2) 12 times
Enter-Edit Path F9-Export one entity F10-Export all entities Esc-Exit
▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓
▓┌───────────────────────────────────────────────────────────────┐▓▓▓▓▓▓▓▓
▓│ │▓▓▓▓▓▓▓▓
▓│ Warning: Be sure all data path are corrected before │▓▓▓▓▓▓▓▓
▓│ exporting budget data. │▓▓▓▓▓▓▓▓
▓│ │▓▓▓▓▓▓▓▓
▓└───────────────────────────────────────────────────────────────┘▓▓▓▓▓▓▓▓
▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓
▓╒═[ Export budget data to DBF files ]════════════════════[ 1 of 3 ]═╕▓▓
▓│ID NAME PATH │▓▓
▓│═══════════════╤═════════════════╤═══════════════════════════════════│▓▓
▓│101 │ Computer Scienc │ C:\BUDGET\92B101.DBF │▓▓
▓│201 │ Engineering Dep │ C:\BUDGET\92B201.DBF │▓▓
▓│301 │ Business Depart │ C:\BUDGET\92B301.DBF │▓▓
▓│ │ │ │▓▓
▓│ │ │ │▓▓
▓│ │ │ │▓▓
▓│ │ │ │▓▓
▓│ │ │ │▓▓
▓│ │ │ │▓▓
▓╘═══════════════╧═════════════════╧═══════════════════════════════════╛▓▓
▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓
▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓
EDITING PATH - Move the cursor to the entity record where you wish to edit
and press the Enter key. Edit the path and press the Enter key.
Export one entity - Move the cursor to the entity record where you wish
to export and press the F9 key.
Export all entities - press the F10 key to display the overall summary.
2.3.3.3 Export Budget to Ascii Delimited Files
───────────────────────────────────────────────────────────────────
Select option 2 from the Export Option Listing to display the following
screen. You can edit the PATH if necessary.
PATH - A 25 character code to identify the directory and the
output file name.
Output file format:
Budget Year Char (04)
Entity Id Char (14)
Account Code Char (14)
Budget 01 - 12 Numeric (11,2) 12 times
Enter-Edit Path F9-Export one entity F10-Export all entities Esc-Exit
▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓
▓┌───────────────────────────────────────────────────────────────┐▓▓▓▓▓▓▓
▓│ │▓▓▓▓▓▓▓
▓│ Warning: Be sure all data path are corrected before │▓▓▓▓▓▓▓
▓│ exporting budget data. │▓▓▓▓▓▓▓
▓│ │▓▓▓▓▓▓▓
▓└───────────────────────────────────────────────────────────────┘▓▓▓▓▓▓▓
▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓
▓╒═[ Export budget data to Ascii Delimited files ]═══════[ 1 of 3 ]═╕▓▓
▓│ID NAME PATH │▓▓
▓│═══════════════╤═════════════════╤══════════════════════════════════│▓▓
▓│101 │ Computer Scienc │ C:\EIS\ACAD\92B101.ASC │▓▓
▓│201 │ Engineering Dep │ C:\EIS\ACAD\92B201.ASC │▓▓
▓│301 │ Business Depart │ C:\EIS\ACAD\92B301.ASC │▓▓
▓│ │ │ │▓▓
▓│ │ │ │▓▓
▓│ │ │ │▓▓
▓│ │ │ │▓▓
▓│ │ │ │▓▓
▓│ │ │ │▓▓
▓╘═══════════════╧═════════════════╧══════════════════════════════════╛▓▓
▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓
▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓
EDITING PATH - Move the cursor to the entity record where you wish to edit
and press the Enter key. Edit the path and press the Enter key.
Export one entity - Move the cursor to the entity record where you wish
to export and press the F9 key.
Export all entities - press the F10 key to display the overall summary.
2.3.3.4 Export Budget and Actual to Ascii Delimited Files
───────────────────────────────────────────────────────────────────
Select option 4 from the Export Option Listing to display the following
screen. You can edit the PATH if necessary.
PATH - A 25 character code to identify the directory and the
output file name.
Output file format:
Budget Year Char (04)
Entity Id Char (14)
Account Code Char (14)
Budget 01 - 12 Numeric (11,2) 12 times
Actual 01 - 12 Numeric (11,2) 12 times
Enter-Edit Path F9-Export one entity F10-Export all entities Esc-Exit
▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓
▓┌───────────────────────────────────────────────────────────────┐▓▓▓▓▓▓▓
▓│ │▓▓▓▓▓▓▓
▓│ Warning: Be sure all data path are corrected before │▓▓▓▓▓▓▓
▓│ exporting budget data. │▓▓▓▓▓▓▓
▓│ │▓▓▓▓▓▓▓
▓└───────────────────────────────────────────────────────────────┘▓▓▓▓▓▓▓
▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓
▓╒═[ Export budget data to Ascii Delimited files ]═══════[ 1 of 3 ]═╕▓▓
▓│ID NAME PATH │▓▓
▓│═══════════════╤═════════════════╤══════════════════════════════════│▓▓
▓│101 │ Computer Scienc │ C:\EIS\ACAD\92B101.ASC │▓▓
▓│201 │ Engineering Dep │ C:\EIS\ACAD\92B201.ASC │▓▓
▓│301 │ Business Depart │ C:\EIS\ACAD\92B301.ASC │▓▓
▓│ │ │ │▓▓
▓│ │ │ │▓▓
▓│ │ │ │▓▓
▓│ │ │ │▓▓
▓│ │ │ │▓▓
▓│ │ │ │▓▓
▓╘═══════════════╧═════════════════╧══════════════════════════════════╛▓▓
▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓
▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓
EDITING PATH - Move the cursor to the entity record where you wish to edit
and press the Enter key. Edit the path and press the Enter key.
Export one entity - Move the cursor to the entity record where you wish
to export and press the F9 key.
Export all entities - press the F10 key to display the overall summary.
2.3.4 Import Budget Data
───────────────────────────────────────────────────────────────────
Press F7 key on the Budget screen to display the following screen.
It provides the following options:
Option (1) Import budget data from DBF files
Option (2) Import budget data from ascii delimited files
F6-Entity-Budget F7-Export F8-Import F9-Summary
▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓╔══════════════════════════════════════════════════╗▓▓▓
▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓║1. Import budget data from DBF files ║ ▓▓
▓▓╒═ [ Entities ] ══║2. Import budget data from ascii delimited file ║ ▓▓
▓▓│ID ╚══════════════════════════════════════════════════╝ ▓▓
▓▓│═══════════════╤═══════ ▓▓
▓▓│101 │ Computer Science Department │▓▓▓▓▓▓▓▓▓▓▓▓▓▓
▓▓│201 │ Engineering Department │▓▓▓▓▓▓▓▓▓▓▓▓▓▓
▓▓│301 │ Business Department │▓▓▓▓▓▓▓▓▓▓▓▓▓▓
▓▓│991 │ Information Systems │▓▓▓▓▓▓▓▓▓▓▓▓▓▓
▓▓│992 │ Human Resources Department │▓▓▓▓▓▓▓▓▓▓▓▓▓▓
▓▓│993 │ Finance Department │▓▓▓▓▓▓▓▓▓▓▓▓▓▓
▓▓│ │ │▓▓▓▓▓▓▓▓▓▓▓▓▓▓
▓▓│ │ │▓▓▓▓▓▓▓▓▓▓▓▓▓▓
▓▓│ │ │▓▓▓▓▓▓▓▓▓▓▓▓▓▓
▓▓╘═══════════════╧═════════════════════════════════════════╛▓▓▓▓▓▓▓▓▓▓▓▓▓▓
▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓
F1-Help <Esc>Exit
SELECTING IMPORT OPTION - Move the cursor to the option that you wish
to select and press the Enter key.
2.3.4.1 Import Budget data to DBF files
───────────────────────────────────────────────────────────────────
Select option 1 from the Export option box to display the following
screen. Before you export budget data, you must check to make sure
all the data path are corrected so that the system knows where to
locate the output files.
PATH - a 25 character code to identify the directory and the
output file name.
Input file Format:
Budget Year char(4)
Entity Id char(14)
Account No char(14)
Budget 01 - 12 number(11,2) 12 times
Enter-Edit Path F9-Import one entity F10-Import all entities Esc-Exit
▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓
▓┌───────────────────────────────────────────────────────────────┐▓▓▓▓▓▓▓▓
▓│ │▓▓▓▓▓▓▓▓
▓│ Warning: Be sure all data path are corrected before │▓▓▓▓▓▓▓▓
▓│ importing budget data. │▓▓▓▓▓▓▓▓
▓│ │▓▓▓▓▓▓▓▓
▓└───────────────────────────────────────────────────────────────┘▓▓▓▓▓▓▓▓
▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓
▓╒═[ Import budget data to DBF files ]════════════════════[ 1 of 3 ]═╕▓▓
▓│ID NAME PATH │▓▓
▓│═══════════════╤═════════════════╤═══════════════════════════════════│▓▓
▓│101 │ Computer Scienc │ C:\BUDGET\92B101.DBF │▓▓
▓│201 │ Engineering Dep │ C:\BUDGET\92B201.DBF │▓▓
▓│301 │ Business Depart │ C:\BUDGET\92B301.DBF │▓▓
▓│ │ │ │▓▓
▓│ │ │ │▓▓
▓│ │ │ │▓▓
▓│ │ │ │▓▓
▓│ │ │ │▓▓
▓│ │ │ │▓▓
▓╘═══════════════╧═════════════════╧═══════════════════════════════════╛▓▓
▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓
▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓
EDITING PATH - Move the cursor to the entity record where you wish to edit
and press the Enter key. Edit the path and press the Enter key.
Import one entity - Move the cursor to the entity record where you wish
to export and press the F9 key.
Import all entities - press the F10 key to display the overall summary.
2.3.4.2 Importing Budget Data to Ascii Delimited Files
───────────────────────────────────────────────────────────────────
Select option 2 from the Export Option Listing to display the following
screen. You can edit the PATH if necessary.
PATH - A 25 character code to identify the directory and the
output file name.
Output file format:
Budget Year Char (04)
Entity Id Char (14)
Account Code Char (14)
Budget 01 - 12 Numeric (11,2) 12 times
Enter-Edit Path F9-Import one entity F10-Import all entities Esc-Exit
▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓
▓┌───────────────────────────────────────────────────────────────┐▓▓▓▓▓▓▓
▓│ │▓▓▓▓▓▓▓
▓│ Warning: Be sure all data path are corrected before │▓▓▓▓▓▓▓
▓│ importing budget data. │▓▓▓▓▓▓▓
▓│ │▓▓▓▓▓▓▓
▓└───────────────────────────────────────────────────────────────┘▓▓▓▓▓▓▓
▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓
▓╒═[ Import budget data to Ascii Delimited files ]═══════[ 1 of 3 ]═╕▓▓
▓│ID NAME PATH │▓▓
▓│═══════════════╤═════════════════╤══════════════════════════════════│▓▓
▓│101 │ Computer Scienc │ C:\EIS\ACAD\92B101.ASC │▓▓
▓│201 │ Engineering Dep │ C:\EIS\ACAD\92B201.ASC │▓▓
▓│301 │ Business Depart │ C:\EIS\ACAD\92B301.ASC │▓▓
▓│ │ │ │▓▓
▓│ │ │ │▓▓
▓│ │ │ │▓▓
▓│ │ │ │▓▓
▓│ │ │ │▓▓
▓│ │ │ │▓▓
▓╘═══════════════╧═════════════════╧══════════════════════════════════╛▓▓
▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓
▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓
EDITING PATH - Move the cursor to the entity record where you wish to edit
and press the Enter key. Edit the path and press the Enter key.
Import one entity - Move the cursor to the entity record where you wish
to export and press the F9 key.
Import all entities - press the F10 key to display the overall summary.
2.4 REPORTS
───────────────────────────────────────────────────────────────────
Select Reports option from the Menu screen to display the following
screen. It allows you to select one of the following report options:
1. Daily Transactions Report
2. Monthly Budget Report
3. Quarterly budget Report
4. Yearly budget report
┌─────────────────────────────────────────────────────────────────────────┐
│ Tables Entities Reports Utilities Quit │
└─────────────────────────────────────────────────────────────────────────┘
▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓┌────────────────────────┐▓▓▓▓▓▓▓▓▓▓▓▓▓
▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓│Daily Transactions │▓▓▓▓▓▓▓▓▓▓▓▓▓
▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓│Monthly Budget Report │▓▓▓▓▓▓▓▓▓▓▓▓▓
▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓│Quarterly Budget Report │▓▓▓▓▓▓▓▓▓▓▓▓▓
▓▓▓▓▓▓▓▓▓▓▓▓╔═══════════════════════│Yearly Budget Report │═════╗▓▓▓▓▓▓▓
▓▓▓▓▓▓▓▓▓▓▓▓║ │ │ ║▓▓▓▓▓▓▓
▓▓▓▓▓▓▓▓▓▓▓▓║ ST-└────────────────────────┘ ║▓▓▓▓▓▓▓
▓▓▓▓▓▓▓▓▓▓▓▓║ ║▓▓▓▓▓▓▓
▓▓▓▓▓▓▓▓▓▓▓▓║ Budgeting and Actual Tracking System ║▓▓▓▓▓▓▓
▓▓▓▓▓▓▓▓▓▓▓▓║ Version 1.0 ║▓▓▓▓▓▓▓
▓▓▓▓▓▓▓▓▓▓▓▓║ ║▓▓▓▓▓▓▓
▓▓▓▓▓▓▓▓▓▓▓▓║ ║▓▓▓▓▓▓▓
▓▓▓▓▓▓▓▓▓▓▓▓║ Copyright (c) SoftTalk Computing Inc. 1991 ║▓▓▓▓▓▓▓
▓▓▓▓▓▓▓▓▓▓▓▓║ P.O.Box 68028 ║▓▓▓▓▓▓▓
▓▓▓▓▓▓▓▓▓▓▓▓║ Calgary, AB. Canada T3G 3N8 ║▓▓▓▓▓▓▓
▓▓▓▓▓▓▓▓▓▓▓▓║ Phone: (403) 241-1519 ║▓▓▓▓▓▓▓
▓▓▓▓▓▓▓▓▓▓▓▓║ ║▓▓▓▓▓▓▓
▓▓▓▓▓▓▓▓▓▓▓▓╚══════════════════════════════════════════════════════╝▓▓▓▓▓▓▓
▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓
▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓
▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓
SELECT OPTION - Move the cursor the required report option and press
the Enter key to execute the option.
2.4.1 Daily Transactions Report
───────────────────────────────────────────────────────────────────
Select option 1 from the Reports option to display the following
screen. You will require to enter the following parameters before
processing report :
Budget Year - The budget year (i.e. 1992) showing on the report
Entity - A 14 character code to specify the entity showing
on the report. Enter ALL for all entities.
Start-Date - The start-date (mm/dd/yy) of the transactions
showing on the report
End-Date - The end-date (mm/dd/yy) of the transaction
showing on the report
F1-Help F10-Process Esc-Exit
▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓
▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓
▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓
▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓
▓▓▓▓▓┌─ [ Daily Transactions Report ]─────────────────────────────────┐▓▓▓
▓▓▓▓▓│ │▓▓▓
▓▓▓▓▓│ │▓▓▓
▓▓▓▓▓│ Budget Year : 1992 │▓▓▓
▓▓▓▓▓│ Entity : ALL │▓▓▓
▓▓▓▓▓│Start Date (mm/dd/yy) : 07/20/91 │▓▓▓
▓▓▓▓▓│ End Date (mm/dd/yy) : 07/20/91 │▓▓▓
▓▓▓▓▓│ │▓▓▓
▓▓▓▓▓│ │▓▓▓
▓▓▓▓▓└────────────────────────────────────────────────────────────────┘▓▓▓
▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓
▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓
▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓
▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓
RUNNING REPORT - Edit the parameter data if necessary and press the
F10 key to execute.
DATE: 02/01/92 Daily Transactions Report Page: 1
Date Account Transaction Actual Commitment Ref.
__________________________________________________________________________
Entity: 101 Computer Science Department
01/01/92 401 Revenue - Tuition Fee 5,000.00 0 101
01/01/92 503 Telephone 50.00 0 102
01/01/92 502 Office Supplies 50.00 0 103
01/01/92 5011 Salary - Full Time 3,000.00 0 104
2.4.2 Monthly Budget Report
────────────────────────────────────────────────────────────────────
Select option 2 from the Reports option to display the following screen.
This screen provides the following options:
One Entity - This option allows you to print the summary report of
one entity by month.
Group Entities - This option allows you to print the summary report
of a selected group of entities by month.
ALL Entities - This option allows you to print the overall summary
report by month.
Enter-Edit F8-Single Entity F9-Group Entities F10-All Entities
▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓
▓┌────────[ Monthly Budget Vs Actual Report ] ───────────────────┐▓▓▓▓▓▓▓▓▓
▓│ │▓▓▓▓▓▓▓▓▓
▓│This screen provides options to print Single, Group or │▓▓▓▓▓▓▓▓▓
▓│Overall Summary Report. For group summary report, you must │▓▓▓▓▓▓▓▓▓
▓│assign a Group Id to the entities before processing. │▓▓▓▓▓▓▓▓▓
▓└───────────────────────────────────────────────────────────────┘▓▓▓▓▓▓▓▓▓
▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓
▓╒═[ Entities ]══════════════════════════════════════════[ 1 of 6 ]═╕▓▓▓▓
▓│ID NAME GROUP │▓▓▓▓
▓│═══════════════╤═════════════════════════════════════╤══════════════│▓▓▓▓
▓│101 │ Computer Science Department │ ACAD │▓▓▓▓
▓│201 │ Engineering Department │ ACAD │▓▓▓▓
▓│301 │ Business Department │ ACAD │▓▓▓▓
▓│991 │ Information Systems │ ADMN │▓▓▓▓
▓│992 │ Human Resources Department │ ADMN │▓▓▓▓
▓│993 │ Finance Department │ ADMN │▓▓▓▓
▓│ │ │ │▓▓▓▓
▓│ │ │ │▓▓▓▓
▓│ │ │ │▓▓▓▓
▓╘═══════════════╧═════════════════════════════════════╧══════════════╛▓▓▓▓
▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓
▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓
EDITING GROUP ID - Move the cursor to the entity record that you wish
to edit and press the Enter key. Edit the field and press Enter key again.
VIEWING SUMMARY - press the hotkey (i.e. F8 key for one entity) to display
the summary report by month.
Monthly Budget vs Actual Report
1992
Budget Actual Variance Variance Budget Revised
Period Description MON MON MON % YTD Projection
_______________________________________________________________________________
Entity : 01 Computer Science
Period : 01
1 Net Income 12,700 6,270 -6,430 -60.63 12,700 145,970
4 Revenue 17,000 10,000 -7,000 -41.18 17,000 197,000
401 Tuition Fee 15,000 10,000 -5,000 -33.33 15,000 175,000
402 Lab Fee 1,000 0 -1,000 0 1,000 11,000
403 Book Fee 1,000 0 -1,000 0 1,000 11,000
5 Expenses 4,300 3,730 -570 -13.26 4,300 51,030
501 Salary 4,000 3,500 -500 -12.50 4,000 47,500
5011 Salary - Full Time 3,000 3,000 0 0.00 3,000 36,000
5012 Salary - Wages 1,000 500 -500 -50.00 1,000 11,500
502 Office Supplies 100 80 -20 -20.00 100 1,180
503 Telephone 100 50 -50 -50.00 100 1,150
504 Insurance 100 100 0 0.00 100 1,200
2.4.3 Quarterly Budget Report
────────────────────────────────────────────────────────────────────
Select option 3 from the Reports option to display the following screen.
This screen provides the following options:
One Entity - This option allows you to print the summary of one
entity by quarter.
Group Entities - This option allows you to print the summary report
of a selected group entities by quarter.
ALL Entities - This option allows you to print the overall summary
report by quarter.
Enter-Edit F8-Single Entity F9-Group Entities F10-All Entities
▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓
▓┌────────[ Quarterly Budget Vs Actual Report ] ─────────────────┐▓▓▓▓▓▓▓▓▓
▓│ │▓▓▓▓▓▓▓▓▓
▓│This screen provides options to print Single, Group or │▓▓▓▓▓▓▓▓▓
▓│Overall Summary Report. For group summary report, you must │▓▓▓▓▓▓▓▓▓
▓│assign a Group Id to the entities before processing. │▓▓▓▓▓▓▓▓▓
▓└───────────────────────────────────────────────────────────────┘▓▓▓▓▓▓▓▓▓
▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓
▓╒═[ Entities ]══════════════════════════════════════════[ 1 of 6 ]═╕▓▓▓▓
▓│ID NAME GROUP │▓▓▓▓
▓│═══════════════╤═════════════════════════════════════╤══════════════│▓▓▓▓
▓│101 │ Computer Science Department │ ACAD │▓▓▓▓
▓│201 │ Engineering Department │ ACAD │▓▓▓▓
▓│301 │ Business Department │ ACAD │▓▓▓▓
▓│991 │ Information Systems │ ADMN │▓▓▓▓
▓│992 │ Human Resources Department │ ADMN │▓▓▓▓
▓│993 │ Finance Department │ ADMN │▓▓▓▓
▓│ │ │ │▓▓▓▓
▓│ │ │ │▓▓▓▓
▓│ │ │ │▓▓▓▓
▓╘═══════════════╧═════════════════════════════════════╧══════════════╛▓▓▓▓
▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓
▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓
Quarterly Budget vs Actual Report
1992
Budget Actual Variance Variance Budget Revised
Period Description QTR QTR QTR % YTD Projection
_______________________________________________________________________________
Entity : 01 Computer Science
Quarter : 01
1 Net Income 38,100 18,510 -19,590 -51.42 18,510 132,810
4 Revenue 51,000 30,000 -21,000 -41.18 30,000 187,000
401 Tuition Fee 45,000 30,000 -15,000 -33.33 30,000 165,000
402 Lab Fee 3,000 0 -3,000 0 0 9,000
403 Book Fee 3,000 0 -3,000 0 0 9,000
5 Expenses 12,000 11,490 -1,410 -10.93 11,490 50,190
501 Salary 12,000 10,850 -1,150 -9.58 10,850 46,850
5011 Salary - Full Time 9,000 9,000 0 0.00 9,000 36,000
5012 Salary - Wages 3,000 1,850 -1,150 -38.33 1,850 10,850
502 Office Supplies 300 290 -10 -3.33 290 1,190
503 Telephone ■■ 300 250 -50 -16.67 290 1,150
504 Insurance 300 100 -200 -66.67 100 1,000
2.4.4 Yearly Budget Report
───────────────────────────────────────────────────────────────────
Select option 4 from the Reports option to display the following screen.
This screen provides the following options:
One Entity - This option allows you to print the summary report of
one single selected entity by year.
Group Entities - This option allows you to print the summary report of
a selected group entities by year.
ALL Entities - This option allows you to print the overall summary report
by year.
Enter-Edit F8-Single Entity F9-Group Entities F10-All Entities
▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓
▓┌──────── [ Yearly Budget Vs Actual Report ] ───────────────────┐▓▓▓▓▓▓▓▓▓
▓│ │▓▓▓▓▓▓▓▓▓
▓│This screen provides options to print Single, Group or │▓▓▓▓▓▓▓▓▓
▓│Overall Summary Report. For group summary report, you must │▓▓▓▓▓▓▓▓▓
▓│assign a Group Id to the entities before processing. │▓▓▓▓▓▓▓▓▓
▓└───────────────────────────────────────────────────────────────┘▓▓▓▓▓▓▓▓▓
▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓
▓╒═[ Entities ]══════════════════════════════════════════[ 1 of 6 ]═╕▓▓▓▓
▓│ID NAME GROUP │▓▓▓▓
▓│═══════════════╤═════════════════════════════════════╤══════════════│▓▓▓▓
▓│101 │ Computer Science Department │ ACAD │▓▓▓▓
▓│201 │ Engineering Department │ ACAD │▓▓▓▓
▓│301 │ Business Department │ ACAD │▓▓▓▓
▓│991 │ Information Systems │ ADMN │▓▓▓▓
▓│992 │ Human Resources Department │ ADMN │▓▓▓▓
▓│993 │ Finance Department │ ADMN │▓▓▓▓
▓│ │ │ │▓▓▓▓
▓│ │ │ │▓▓▓▓
▓│ │ │ │▓▓▓▓
▓╘═══════════════╧═════════════════════════════════════╧══════════════╛▓▓▓▓
▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓
▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓
EDIDING GROUP ID - Move the cursor to the entity record where you wish
and press the Enter key. Edit the group field and press the Enter key.
VIEWING SUMMARY - Press the Hotkey (i.e. Press F8 key for one entity)
to display the summary.
DATE: 02/01/92 Yearly Budget Report Page: 1
1992
Account Description Budget Actual Variance
--------------------------------------------------------------------
Entity: 01 Computer Science Department
1 Net Income 92,400 16,260 -76,140
4 Revenues 144,000 27,750 -116,250
401 Tuition Fee 120,000 0 -92,250
402 Lab Fee 12,000 0 -12,000
403 Book Fee 12,000 0 -12,000
5 Expenses 51,600 11,490 -40,100
501 Salary 48,000 10,850 -37,150
5011 Salary - Full Time 36,000 9,000 -27,000
5012 Salary - Wages 12,000 1,850 -10,150
502 Office Supplies 1,200 290 -910
503 Telephone 1,200 250 950
504 Insurance 1,200 100 1,100
2.5 UTILITIES MENU
─────────────────────────────────────────────────────────────────────────
The following screen will be displayed when the Utilities option is
selected from the Menu. It allows you to select one of the following
options to execute:
INITIALIZE DATABASE - this option allows you to re-initialize
all data files. All existing records in the database will be purged.
REBUILD INDEXES - this option allows you to re-build the indexes
of all existing data files.
BACKUP DATABASE FILES - this option allows you to save all existing
data files into backup diskettes.
RESTORE DATABASE FILES - this option allows you to restore all data
files from backup diskettes.
┌─────────────────────────────────────────────────────────────────────────┐
│ Tables Entities Reports Utilities Quit │
└─────────────────────────────────────────────────────────────────────────┘
▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓┌──────────────────────┐▓▓▓▓▓▓
▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓│Initialize Database │▓▓▓▓▓▓
▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓│Rebuild Indexes │▓▓▓▓▓▓
▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓│Back Up Database Files│▓▓▓▓▓▓
▓▓▓▓▓▓▓▓▓▓▓▓╔════════════════════════════════│Restore Database Files│▓▓▓▓▓▓
▓▓▓▓▓▓▓▓▓▓▓▓║ └──────────────────────┘▓▓▓▓▓▓
▓▓▓▓▓▓▓▓▓▓▓▓║ ST-BUDGET ║▓▓▓▓▓▓▓
▓▓▓▓▓▓▓▓▓▓▓▓║ ║▓▓▓▓▓▓▓
▓▓▓▓▓▓▓▓▓▓▓▓║ Budget Tracking System ║▓▓▓▓▓▓▓
▓▓▓▓▓▓▓▓▓▓▓▓║ Version 1.6 ║▓▓▓▓▓▓▓
▓▓▓▓▓▓▓▓▓▓▓▓║ ║▓▓▓▓▓▓▓
▓▓▓▓▓▓▓▓▓▓▓▓║ ║▓▓▓▓▓▓▓
▓▓▓▓▓▓▓▓▓▓▓▓║ Copyright (c) SoftTalk Computing Inc. 1991-1992 ║▓▓▓▓▓▓▓
▓▓▓▓▓▓▓▓▓▓▓▓║ P.O.Box 68028 ║▓▓▓▓▓▓▓
▓▓▓▓▓▓▓▓▓▓▓▓║ Calgary, AB. Canada T3G 3N8 ║▓▓▓▓▓▓▓
▓▓▓▓▓▓▓▓▓▓▓▓║ Phone: (403) 241-1519 ║▓▓▓▓▓▓▓
▓▓▓▓▓▓▓▓▓▓▓▓║ ║▓▓▓▓▓▓▓
▓▓▓▓▓▓▓▓▓▓▓▓╚══════════════════════════════════════════════════════╝▓▓▓▓▓▓▓
▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓
▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓
▓▓▓▓▓Press F1 key for help menu, Enter key to execute, Esc key to exit▓▓▓▓▓
SELECT OPTION - Move the cursor to the required option and press the
Enter key to execute.
2.5.1 Initialize DataBase
────────────────────────────────────────────────────────────────────────
The following screen will be displayed when the Initialize DataBase option
is selected from the Utilities menu item. It allows you to initialize
all data files so that you can start the system with a new database.
Be sure you backup all files before you run this process.
▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓
▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓
▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓
▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓
▓▓▓▓▓▓▓▓▓▓▓┌─ [ Initialize Database ]─────────────────────────────┐▓▓▓▓▓▓▓
▓▓▓▓▓▓▓▓▓▓▓│ │▓▓▓▓▓▓▓
▓▓▓▓▓▓▓▓▓▓▓│ │▓▓▓▓▓▓▓
▓▓▓▓▓▓▓▓▓▓▓│ Enter Serial Number : │▓▓▓▓▓▓▓
▓▓▓▓▓▓▓▓▓▓▓│ │▓▓▓▓▓▓▓
▓▓▓▓▓▓▓▓▓▓▓│ │▓▓▓▓▓▓▓
▓▓▓▓▓▓▓▓▓▓▓│ │▓▓▓▓▓▓▓
▓▓▓▓▓▓▓▓▓▓▓│ │▓▓▓▓▓▓▓
▓▓▓▓▓▓▓▓▓▓▓│ │▓▓▓▓▓▓▓
▓▓▓▓▓▓▓▓▓▓▓└──────────────────────────────────────────────────────┘▓▓▓▓▓▓▓
▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓
▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓
▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓
▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓
RUN OPTION - Enter the Serial Number and press Enter key ( Demo version
does not require serial number).
2.5.2 Rebuild Index Files
────────────────────────────────────────────────────────────────────
Select the "Rebuild Indexes" option from the Utilities menu to pop up
the following screen. It allows you rebuild all the index files.
▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓
▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓
▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓
▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓┌───────────────────────────────────────┐▓▓▓▓▓▓▓▓▓▓▓▓▓
▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓│ │▓▓▓▓▓▓▓▓▓▓▓▓▓
▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓│ Are you sure you want to re-build all │▓▓▓▓▓▓▓▓▓▓▓▓▓
▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓│ index files ? │▓▓▓▓▓▓▓▓▓▓▓▓▓
▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓│ │▓▓▓▓▓▓▓▓▓▓▓▓▓
▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓│ │▓▓▓▓▓▓▓▓▓▓▓▓▓
▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓│ │▓▓▓▓▓▓▓▓▓▓▓▓▓
▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓│ │▓▓▓▓▓▓▓▓▓▓▓▓▓
▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓│ Yes No │▓▓▓▓▓▓▓▓▓▓▓▓▓
▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓│ │▓▓▓▓▓▓▓▓▓▓▓▓▓
▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓└───────────────────────────────────────┘▓▓▓▓▓▓▓▓▓▓▓▓▓
▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓
▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓
▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓
REBUILDING INDEX FILES - Press the "Yes" button if you wish to rebuild
all the index files. Otherwise, press "No" button to exit.
2.5.3 Backup DataBase Files
─────────────────────────────────────────────────────────────────────
Select the "Backup Database Files" option from the Utilities menu to
pop up the following screen. It allows you to save a backup copy of the
current database tables into other area.
The default backup drive is A, but you can change it to B if you wish.
F1-Help F10-Process Esc-Exit
▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓
▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓
▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓
▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓
▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓
▓▓▓▓▓▓▓▓▓▓▓┌─ [ Backup Database Files]────────────────────────────┐▓▓▓▓▓▓▓
▓▓▓▓▓▓▓▓▓▓▓│ │▓▓▓▓▓▓▓
▓▓▓▓▓▓▓▓▓▓▓│ │▓▓▓▓▓▓▓
▓▓▓▓▓▓▓▓▓▓▓│ │▓▓▓▓▓▓▓
▓▓▓▓▓▓▓▓▓▓▓│ Enter Drive : A │▓▓▓▓▓▓▓
▓▓▓▓▓▓▓▓▓▓▓│ │▓▓▓▓▓▓▓
▓▓▓▓▓▓▓▓▓▓▓│ │▓▓▓▓▓▓▓
▓▓▓▓▓▓▓▓▓▓▓│ │▓▓▓▓▓▓▓
▓▓▓▓▓▓▓▓▓▓▓│ │▓▓▓▓▓▓▓
▓▓▓▓▓▓▓▓▓▓▓└──────────────────────────────────────────────────────┘▓▓▓▓▓▓▓
▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓
▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓
▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓
Enter the drive ( A or B ) and press the F10 key to process.
2.5.4 Restore DataBase Files
────────────────────────────────────────────────────────────────────
Select the "Restore Database Files" option from the Utilities menu to
pop up the following screen. It allows you to restore the Database tables
from the backup diskette.
The default backup drive is A, but you can change it to B if you wish.
F1-Help F10-Process Esc-Exit
▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓
▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓
▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓
▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓
▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓
▓▓▓▓▓▓▓▓▓▓▓┌─ [ Restore Database Files ]──────────────────────────┐▓▓▓▓▓▓▓
▓▓▓▓▓▓▓▓▓▓▓│ │▓▓▓▓▓▓▓
▓▓▓▓▓▓▓▓▓▓▓│ │▓▓▓▓▓▓▓
▓▓▓▓▓▓▓▓▓▓▓│ │▓▓▓▓▓▓▓
▓▓▓▓▓▓▓▓▓▓▓│ Enter Drive : A │▓▓▓▓▓▓▓
▓▓▓▓▓▓▓▓▓▓▓│ │▓▓▓▓▓▓▓
▓▓▓▓▓▓▓▓▓▓▓│ │▓▓▓▓▓▓▓
▓▓▓▓▓▓▓▓▓▓▓│ │▓▓▓▓▓▓▓
▓▓▓▓▓▓▓▓▓▓▓│ │▓▓▓▓▓▓▓
▓▓▓▓▓▓▓▓▓▓▓└──────────────────────────────────────────────────────┘▓▓▓▓▓▓▓
▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓
▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓
▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓
Enter the drive (A or B) and then press the F10 key to process.